/*
 Navicat Premium Data Transfer

 Source Server         : prod-oracle
 Source Server Type    : Oracle
 Source Server Version : 110200
 Source Host           : prod-oracle:1521
 Source Schema         : JACK

 Target Server Type    : Oracle
 Target Server Version : 110200
 File Encoding         : 65001

 Date: 14/08/2023 14:30:58
*/


-- ----------------------------
-- Table structure for IO_PIC_DBLINK
-- ----------------------------

CREATE TABLE "JACK"."IO_PIC_DBLINK" (
  "ID" NUMBER NOT NULL,
  "PIC_INPUTSTREAM" BLOB,
  "PIC_PATH" VARCHAR2(255 BYTE),
  "PIC_TYPE" NUMBER DEFAULT 0
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."IO_PIC_DBLINK"."PIC_INPUTSTREAM" IS '图片二进制形式存放';
COMMENT ON COLUMN "JACK"."IO_PIC_DBLINK"."PIC_PATH" IS '图片路径';
COMMENT ON COLUMN "JACK"."IO_PIC_DBLINK"."PIC_TYPE" IS '图片类型：0：二维码  1：条形码  2：普通图片';

-- ----------------------------
-- Table structure for TB_BARCODE
-- ----------------------------

CREATE TABLE "JACK"."TB_BARCODE" (
  "BC_ID" NUMBER NOT NULL,
  "BC_JF" VARCHAR2(100 BYTE),
  "BC_FJ" VARCHAR2(100 BYTE),
  "BC_JG" VARCHAR2(100 BYTE),
  "BC_WZU" VARCHAR2(100 BYTE),
  "BC_GD" VARCHAR2(100 BYTE),
  "BC_BQ" VARCHAR2(100 BYTE),
  "BC_SN" VARCHAR2(100 BYTE),
  "BC_XH" VARCHAR2(100 BYTE),
  "BC_PZT" VARCHAR2(100 BYTE),
  "BC_WKMK" VARCHAR2(100 BYTE),
  "BC_MAC" VARCHAR2(100 BYTE),
  "BC_BDBQ" VARCHAR2(100 BYTE),
  "BC_DUBQ" VARCHAR2(100 BYTE),
  "BC_JHJ" VARCHAR2(100 BYTE),
  "BC_GLIP" VARCHAR2(100 BYTE),
  "BC_NWIP" VARCHAR2(100 BYTE),
  "BC_SJSJ" VARCHAR2(100 BYTE),
  "BC_YT" VARCHAR2(100 BYTE),
  "BC_GS" VARCHAR2(100 BYTE),
  "BC_GHDW" VARCHAR2(100 BYTE),
  "BC_CPU" VARCHAR2(100 BYTE),
  "BC_NC" VARCHAR2(100 BYTE),
  "BC_XK" VARCHAR2(100 BYTE),
  "BC_YP" VARCHAR2(100 BYTE),
  "BC_ID_MD5" VARCHAR2(100 BYTE),
  "BC_BM" VARCHAR2(100 BYTE),
  "BC_PICID" VARCHAR2(100 BYTE),
  "BC_YYS" VARCHAR2(50 BYTE),
  "REAL_CODE" VARCHAR2(50 BYTE),
  "BC_LB" VARCHAR2(50 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_JF" IS '机房';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_FJ" IS '房间';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_JG" IS '机柜';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_WZU" IS '位置';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_GD" IS '高度';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_BQ" IS '标签(专网HOST)';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_SN" IS 'SN';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_XH" IS '型号';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_PZT" IS '项目状态';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_WKMK" IS '网卡模块';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_MAC" IS 'mac地址';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_BDBQ" IS '本端标签';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_DUBQ" IS '对端标签';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_JHJ" IS '交换机端口';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_GLIP" IS '管理IP';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_NWIP" IS '内网IP';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_SJSJ" IS '上架时间';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_YT" IS '用途 (动态人像、一脸一档、已入网)';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_GS" IS '归属';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_GHDW" IS '供货单位';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_CPU" IS 'cpu';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_NC" IS '内存';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_XK" IS '显卡';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_YP" IS '硬盘';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_ID_MD5" IS 'bc_id对应的md5加密串';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_BM" IS '条形码20位编码';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_PICID" IS '图片id';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_YYS" IS '运营商编码';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."REAL_CODE" IS '真实条形码编码';
COMMENT ON COLUMN "JACK"."TB_BARCODE"."BC_LB" IS '设备类别';

-- ----------------------------
-- Table structure for TB_DEVICE_DATA
-- ----------------------------

CREATE TABLE "JACK"."TB_DEVICE_DATA" (
  "DEVICE_CODE_ID" NUMBER NOT NULL,
  "DEVICE_LABLE" VARCHAR2(50 BYTE),
  "DEVICE_VALUE" VARCHAR2(50 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Table structure for TB_DEVICE_STATUS
-- ----------------------------

CREATE TABLE "JACK"."TB_DEVICE_STATUS" (
  "DEVICE_CODE_ID" NUMBER NOT NULL,
  "DEVICE_LABLE" VARCHAR2(50 BYTE),
  "DEVICE_VALUE" VARCHAR2(50 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Table structure for TB_DICT_DATA
-- ----------------------------

CREATE TABLE "JACK"."TB_DICT_DATA" (
  "DICT_CODE_ID" NUMBER NOT NULL,
  "DICT_SORT" NUMBER,
  "DICT_LABEL" VARCHAR2(100 BYTE),
  "DICT_VALUE" VARCHAR2(50 BYTE),
  "DICT_TYPE" VARCHAR2(50 BYTE),
  "STATUS" VARCHAR2(10 BYTE),
  "CREATE_BY" VARCHAR2(50 BYTE),
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(50 BYTE),
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(100 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."DICT_CODE_ID" IS '字典编码';
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."DICT_SORT" IS '字典排序';
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."DICT_LABEL" IS '字典标签';
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."DICT_VALUE" IS '字典键值';
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."DICT_TYPE" IS '字典类型';
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."STATUS" IS '状态（0正常 1停用）';
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "JACK"."TB_DICT_DATA"."REMARK" IS '备注';

-- ----------------------------
-- Table structure for TB_DICT_TYPE
-- ----------------------------

CREATE TABLE "JACK"."TB_DICT_TYPE" (
  "DICT_ID" NUMBER NOT NULL,
  "DICT_NAME" VARCHAR2(50 BYTE),
  "DICT_TYPE" VARCHAR2(50 BYTE),
  "STATUS" VARCHAR2(10 BYTE),
  "CREATE_BY" VARCHAR2(50 BYTE),
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(50 BYTE),
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(50 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_DICT_TYPE"."DICT_ID" IS '字典主键';
COMMENT ON COLUMN "JACK"."TB_DICT_TYPE"."DICT_NAME" IS '字典名称';
COMMENT ON COLUMN "JACK"."TB_DICT_TYPE"."DICT_TYPE" IS '字典类型';
COMMENT ON COLUMN "JACK"."TB_DICT_TYPE"."STATUS" IS '状态（0正常 1停用）';
COMMENT ON COLUMN "JACK"."TB_DICT_TYPE"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "JACK"."TB_DICT_TYPE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JACK"."TB_DICT_TYPE"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "JACK"."TB_DICT_TYPE"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "JACK"."TB_DICT_TYPE"."REMARK" IS '备注';

-- ----------------------------
-- Table structure for TB_EARLY_WARNING
-- ----------------------------

CREATE TABLE "JACK"."TB_EARLY_WARNING" (
  "early_warning_id" NUMBER NOT NULL,
  "id" LONG,
  "name" VARCHAR2(255 BYTE),
  "idCardNo" VARCHAR2(255 BYTE),
  "sceneImageUrl" VARCHAR2(255 BYTE),
  "faceImageUrl" VARCHAR2(255 BYTE),
  "collectionImageUrl" VARCHAR2(255 BYTE),
  "snapshotTime" VARCHAR2(255 BYTE),
  "receiveAlertTime" VARCHAR2(255 BYTE),
  "similarScore" NUMBER,
  "similarity" NUMBER,
  "warningType" VARCHAR2(255 BYTE),
  "warningColor" VARCHAR2(255 BYTE),
  "dataSource" VARCHAR2(50 BYTE),
  "triggerLocation" VARCHAR2(100 BYTE),
  "triggerTime" NUMBER,
  "collectionCode" VARCHAR2(255 BYTE),
  "collectionName" VARCHAR2(255 BYTE),
  "isDeliver" NUMBER(1,0) DEFAULT 0,
  "notDeliveredReason" VARCHAR2(255 BYTE),
  "deliverDeptCode" VARCHAR2(100 BYTE),
  "deliverDept" VARCHAR2(200 BYTE),
  "createTime" NUMBER,
  "issueTime" NUMBER,
  "deviceId" VARCHAR2(200 BYTE),
  "deployReason" VARCHAR2(255 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."early_warning_id" IS '预警编号';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."id" IS '预警编号';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."name" IS '预警对象名称';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."idCardNo" IS '预警对象身份证号';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."sceneImageUrl" IS '场景图url，人像预警才有';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."faceImageUrl" IS '人脸图url，人像预警才有';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."collectionImageUrl" IS '底库图url，人像预警才有';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."snapshotTime" IS '抓拍时间戳，精确到毫秒';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."receiveAlertTime" IS '系统接收时间戳，精确到毫秒';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."similarScore" IS '1:N相似度';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."similarity" IS '1:1相似度';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."warningType" IS '预警类型 struct、image、car、imsi';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."warningColor" IS '预警颜色，red/orange/yellow/green/black';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."dataSource" IS '预警来源类型：
HOTEL=旅馆登记
INTERNET_BAR_ONLINE=网吧登记
PARK_APPT=园林预约
CAMERA=人像抓拍
REN_KA=人像抓拍(人卡)
CHAO_KA=人像抓拍(超卡)
REN_ZHENG_HE_YAN=人像抓拍(人证核验)
4G_ZHI_FA_JI_LU_YI=人像抓拍(4G执法记录仪)
BU_KONG_QIU=人像抓拍(布控球)
CAR=车卡抓拍
IMSI=手机IMSI';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."triggerLocation" IS '预警地点';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."triggerTime" IS '预警时间戳';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."collectionCode" IS '布控库code';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."collectionName" IS '布控库名称';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."isDeliver" IS '是否下发 0=否，1=是';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."notDeliveredReason" IS '未下发原因';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."deliverDeptCode" IS '下发单位编号';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."deliverDept" IS '下发单位名称';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."createTime" IS '预警产生时间戳';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."issueTime" IS '预警下发时间戳';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."deviceId" IS '抓拍设备国标编号';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING"."deployReason" IS '布控事由';
COMMENT ON TABLE "JACK"."TB_EARLY_WARNING" IS '预警列表';

-- ----------------------------
-- Table structure for TB_EARLY_WARNING_WORK
-- ----------------------------

CREATE TABLE "JACK"."TB_EARLY_WARNING_WORK" (
  "EWW_ID" NUMBER NOT NULL,
  "POLICE_NO" VARCHAR2(20 BYTE),
  "POLICE_NAME" VARCHAR2(20 BYTE),
  "POLICE_DEPT_ID" VARCHAR2(50 BYTE),
  "POLICE_DEPT_NAME" VARCHAR2(200 BYTE),
  "POLICE_CELL_PHONE" VARCHAR2(50 BYTE),
  "AREA_CODE" VARCHAR2(30 BYTE),
  "AREA_NAME" VARCHAR2(30 BYTE),
  "EQUIP_LIST" VARCHAR2(500 BYTE),
  "DESCRIPTION" VARCHAR2(400 BYTE),
  "QR_ID_MD5" VARCHAR2(100 BYTE),
  "WARNING_COLOR" NUMBER,
  "WARNING_TYPE" NUMBER,
  "STARTTIME" DATE,
  "ENDTIME" DATE,
  "POLICEDEVICEID" VARCHAR2(20 BYTE),
  "APPLY_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."POLICE_NO" IS '民警警号';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."POLICE_NAME" IS '民警姓名';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."POLICE_DEPT_ID" IS '民警部门编码';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."POLICE_DEPT_NAME" IS '民警部门名称';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."POLICE_CELL_PHONE" IS '民警联系电话';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."AREA_CODE" IS '监控设备所属行政区域编码';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."AREA_NAME" IS '监控设备所属行政区域名称';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."EQUIP_LIST" IS '监控设备列表Json格式';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."DESCRIPTION" IS '请求事宜描述';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."QR_ID_MD5" IS '二维码IdMD5值';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."WARNING_COLOR" IS '预警信息类别 红：0橙：1黄：2绿：3黑：4白：5';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."WARNING_TYPE" IS '人卡：0人证核验：1超卡：2';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."STARTTIME" IS '临时查看时效-起始时间';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."ENDTIME" IS '临时查看时效-结束时间';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."POLICEDEVICEID" IS '警务通设备ID';
COMMENT ON COLUMN "JACK"."TB_EARLY_WARNING_WORK"."APPLY_TIME" IS '申请时间';

-- ----------------------------
-- Table structure for TB_EQUIPMEN
-- ----------------------------

CREATE TABLE "JACK"."TB_EQUIPMEN" (
  "EQ_ID" NUMBER NOT NULL,
  "QR_ID" NUMBER,
  "SB_ID" NUMBER,
  "GW_ID" NUMBER,
  "JK_ID" NUMBER,
  "YJ_ID" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_EQUIPMEN"."EQ_ID" IS '关联设备主键ID';
COMMENT ON COLUMN "JACK"."TB_EQUIPMEN"."QR_ID" IS '二维码ID';
COMMENT ON COLUMN "JACK"."TB_EQUIPMEN"."SB_ID" IS '前端摄像机ID';
COMMENT ON COLUMN "JACK"."TB_EQUIPMEN"."GW_ID" IS '监控杆位ID';
COMMENT ON COLUMN "JACK"."TB_EQUIPMEN"."JK_ID" IS '监控系统ID';
COMMENT ON COLUMN "JACK"."TB_EQUIPMEN"."YJ_ID" IS '一机一档 ID';

-- ----------------------------
-- Table structure for TB_EQUIP_BINDING_WORK
-- ----------------------------

CREATE TABLE "JACK"."TB_EQUIP_BINDING_WORK" (
  "EBW_ID" NUMBER NOT NULL,
  "TEMP_USER_NAME" VARCHAR2(30 BYTE),
  "POLE_ID" NUMBER,
  "POLE_LOGITUDE" NUMBER(30,20),
  "POLE_LATITUDE" NUMBER(30,20),
  "CONTENT" VARCHAR2(200 BYTE),
  "PICID" VARCHAR2(100 BYTE),
  "REPORT_ADDRESS" VARCHAR2(255 BYTE),
  "EVENT_TYPE" NUMBER,
  "EBW_STATE" NUMBER DEFAULT 0,
  "REPORT_TIME" DATE,
  "HANDLE_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."EBW_ID" IS '主键ID';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."TEMP_USER_NAME" IS '工程APP的临时用户名';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."POLE_ID" IS '杆件ID';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."POLE_LOGITUDE" IS '杆件当前经度';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."POLE_LATITUDE" IS '杆件当前纬度';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."CONTENT" IS '上报内容';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."PICID" IS '图片ID';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."REPORT_ADDRESS" IS '上报地址';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."EVENT_TYPE" IS '事件上报类型';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."EBW_STATE" IS '设备绑定工单状态 0待处理，1已处理';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."REPORT_TIME" IS '上报时间';
COMMENT ON COLUMN "JACK"."TB_EQUIP_BINDING_WORK"."HANDLE_TIME" IS '处理时间';

-- ----------------------------
-- Table structure for TB_IVS_CAMERA
-- ----------------------------

CREATE TABLE "JACK"."TB_IVS_CAMERA" (
  "CAMERA_ID" NUMBER NOT NULL,
  "GBID" VARCHAR2(50 BYTE),
  "CODE" VARCHAR2(100 BYTE),
  "CAMERA_CODE" VARCHAR2(50 BYTE),
  "CAMERA_NAME" VARCHAR2(200 BYTE),
  "CAMERA_TYPE" NUMBER,
  "DOMAIN_CODE" VARCHAR2(50 BYTE),
  "GROUP_CODE" VARCHAR2(50 BYTE),
  "CREATE_TIME" DATE DEFAULT SYSDATE,
  "UPDATE_TIME" DATE DEFAULT SYSDATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_IVS_CAMERA"."CAMERA_ID" IS '主键';
COMMENT ON COLUMN "JACK"."TB_IVS_CAMERA"."GBID" IS '摄像机国标编码';
COMMENT ON COLUMN "JACK"."TB_IVS_CAMERA"."CODE" IS '编码';
COMMENT ON COLUMN "JACK"."TB_IVS_CAMERA"."CAMERA_CODE" IS '摄像机编码';
COMMENT ON COLUMN "JACK"."TB_IVS_CAMERA"."CAMERA_NAME" IS '摄像机名称';
COMMENT ON COLUMN "JACK"."TB_IVS_CAMERA"."CAMERA_TYPE" IS '摄像机类型，0固定枪机，1有云台枪机，2球机，3半球机，4筒机';
COMMENT ON COLUMN "JACK"."TB_IVS_CAMERA"."DOMAIN_CODE" IS '域编码';
COMMENT ON COLUMN "JACK"."TB_IVS_CAMERA"."GROUP_CODE" IS '设备组编码';
COMMENT ON COLUMN "JACK"."TB_IVS_CAMERA"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JACK"."TB_IVS_CAMERA"."UPDATE_TIME" IS '更新时间';

-- ----------------------------
-- Table structure for TB_JKGW
-- ----------------------------

CREATE TABLE "JACK"."TB_JKGW" (
  "GW_ID" NUMBER DEFAULT 0 NOT NULL,
  "GW_NAME" VARCHAR2(200 BYTE),
  "GW_WZ" VARCHAR2(200 BYTE),
  "GW_BW" VARCHAR2(50 BYTE),
  "GW_JD" NUMBER(30,20),
  "GW_WD" NUMBER(30,20),
  "GW_ZX" VARCHAR2(50 BYTE),
  "GW_BM" VARCHAR2(50 BYTE),
  "QRID_MD5" VARCHAR2(100 BYTE),
  "GW_SEARCH_RADIUS" NUMBER(10,6),
  "BIND_TIME" DATE,
  "MODIFY_TIME" DATE,
  "TOWN_CODE" VARCHAR2(100 BYTE),
  "TOWN_NAME" VARCHAR2(100 BYTE),
  "AREA_CODE" VARCHAR2(100 BYTE),
  "AREA_NAME" VARCHAR2(100 BYTE),
  "WAIT_CHECK" VARCHAR2(255 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_JKGW"."GW_ID" IS '杆位编号';
COMMENT ON COLUMN "JACK"."TB_JKGW"."GW_NAME" IS '杆位名称';
COMMENT ON COLUMN "JACK"."TB_JKGW"."GW_WZ" IS '杆位位置';
COMMENT ON COLUMN "JACK"."TB_JKGW"."GW_BW" IS '所属部位';
COMMENT ON COLUMN "JACK"."TB_JKGW"."GW_JD" IS '杆位位置经度';
COMMENT ON COLUMN "JACK"."TB_JKGW"."GW_WD" IS '杆位位置纬度';
COMMENT ON COLUMN "JACK"."TB_JKGW"."GW_ZX" IS '路段走向';
COMMENT ON COLUMN "JACK"."TB_JKGW"."GW_BM" IS '二维码编码';
COMMENT ON COLUMN "JACK"."TB_JKGW"."QRID_MD5" IS 'qrid对应的MD5加密串';
COMMENT ON COLUMN "JACK"."TB_JKGW"."GW_SEARCH_RADIUS" IS '杆位搜索半径';
COMMENT ON COLUMN "JACK"."TB_JKGW"."BIND_TIME" IS '绑定时间';
COMMENT ON COLUMN "JACK"."TB_JKGW"."TOWN_CODE" IS '街道行政区域编码';
COMMENT ON COLUMN "JACK"."TB_JKGW"."TOWN_NAME" IS '街道名称';
COMMENT ON COLUMN "JACK"."TB_JKGW"."AREA_CODE" IS '行政区域编码';
COMMENT ON COLUMN "JACK"."TB_JKGW"."AREA_NAME" IS '行政区域名称';
COMMENT ON COLUMN "JACK"."TB_JKGW"."WAIT_CHECK" IS '是否待检查';

-- ----------------------------
-- Table structure for TB_JKXT
-- ----------------------------

CREATE TABLE "JACK"."TB_JKXT" (
  "JK_ID" NUMBER NOT NULL,
  "JK_NAME" VARCHAR2(50 BYTE),
  "JK_GLCODE" VARCHAR2(50 BYTE),
  "JK_GLNAME" VARCHAR2(50 BYTE),
  "JK_SZD" VARCHAR2(50 BYTE),
  "JK_CZWL" VARCHAR2(50 BYTE),
  "JK_LW" VARCHAR2(50 BYTE),
  "JK_GB" VARCHAR2(50 BYTE),
  "JK_ZQ" VARCHAR2(50 BYTE),
  "JK_LXR" VARCHAR2(50 BYTE),
  "JK_TEL" VARCHAR2(50 BYTE),
  "JK_ADDRES" VARCHAR2(50 BYTE),
  "JK_HY" VARCHAR2(50 BYTE),
  "JK_TYPE" VARCHAR2(50 BYTE),
  "JK_NUMBER" NUMBER,
  "JK_JD" VARCHAR2(50 BYTE),
  "JK_WD" VARCHAR2(50 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_ID" IS '监控系统编号';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_NAME" IS '监控系统名称';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_GLCODE" IS '管理单位代码';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_GLNAME" IS '管理单位名称';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_SZD" IS '监控系统所在地';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_CZWL" IS '承载网络';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_LW" IS '是否联网';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_GB" IS '是否符合国标';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_ZQ" IS '录像存储周期';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_LXR" IS '联系人';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_TEL" IS '联系电话';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_ADDRES" IS '单位地址';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_HY" IS '所属行业';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_TYPE" IS '系统所属类型';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_NUMBER" IS '监控系统摄像机数量';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_JD" IS '监控系统所在位置经度';
COMMENT ON COLUMN "JACK"."TB_JKXT"."JK_WD" IS '监控系统所在位置纬度';

-- ----------------------------
-- Table structure for TB_OP_WORK
-- ----------------------------

CREATE TABLE "JACK"."TB_OP_WORK" (
  "OP_WORK_ID" NUMBER NOT NULL,
  "REPAIRE_ID" VARCHAR2(100 BYTE),
  "DEV_NAME" VARCHAR2(4000 BYTE),
  "DEV_CODE" VARCHAR2(100 BYTE),
  "FAULT_TYPE" VARCHAR2(4000 BYTE),
  "FAULT_REMARK" VARCHAR2(4000 BYTE),
  "REPAIR_STATUS" VARCHAR2(50 BYTE),
  "FAULT_TIME" DATE,
  "RESPONSE_MAN" VARCHAR2(50 BYTE),
  "RESPONSE_TIME" DATE,
  "RESPONSE_REMARK" VARCHAR2(100 BYTE),
  "REPAIR_MAN" VARCHAR2(50 BYTE),
  "REPAIR_TIME" DATE,
  "REPAIR_REMARK" VARCHAR2(4000 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."OP_WORK_ID" IS '主键Id';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."REPAIRE_ID" IS '运维工单编号';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."DEV_NAME" IS '设备名称';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."DEV_CODE" IS '设备编码（GBID）';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."FAULT_TYPE" IS '故障类型';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."FAULT_REMARK" IS '故障描述';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."REPAIR_STATUS" IS '工单状态';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."FAULT_TIME" IS '上报时间';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."RESPONSE_MAN" IS '响应人';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."RESPONSE_TIME" IS '响应时间';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."RESPONSE_REMARK" IS '响应备注';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."REPAIR_MAN" IS '反馈人';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."REPAIR_TIME" IS '反馈时间';
COMMENT ON COLUMN "JACK"."TB_OP_WORK"."REPAIR_REMARK" IS '反馈备注';

-- ----------------------------
-- Table structure for TB_POLE_QRCODE_BIND_HISTORY
-- ----------------------------

CREATE TABLE "JACK"."TB_POLE_QRCODE_BIND_HISTORY" (
  "PQBH_ID" NUMBER NOT NULL,
  "POLE_ID" NUMBER,
  "OLD_QRID_MD5" VARCHAR2(100 BYTE),
  "NEW_QRID_MD5" VARCHAR2(100 BYTE),
  "TMP_USER_ID" NUMBER,
  "CHANGE_BIND_TYPE" NUMBER,
  "CHANGE_BIND_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_POLE_QRCODE_BIND_HISTORY"."PQBH_ID" IS '主键，自增';
COMMENT ON COLUMN "JACK"."TB_POLE_QRCODE_BIND_HISTORY"."POLE_ID" IS '杆位id';
COMMENT ON COLUMN "JACK"."TB_POLE_QRCODE_BIND_HISTORY"."OLD_QRID_MD5" IS '旧的二维码id';
COMMENT ON COLUMN "JACK"."TB_POLE_QRCODE_BIND_HISTORY"."NEW_QRID_MD5" IS '新的二维码id';
COMMENT ON COLUMN "JACK"."TB_POLE_QRCODE_BIND_HISTORY"."TMP_USER_ID" IS '临时用户id';
COMMENT ON COLUMN "JACK"."TB_POLE_QRCODE_BIND_HISTORY"."CHANGE_BIND_TYPE" IS '换绑类型';
COMMENT ON COLUMN "JACK"."TB_POLE_QRCODE_BIND_HISTORY"."CHANGE_BIND_TIME" IS '换绑时间';

-- ----------------------------
-- Table structure for TB_PRIVILEGE
-- ----------------------------

CREATE TABLE "JACK"."TB_PRIVILEGE" (
  "PRIVILEGE_ID" NUMBER NOT NULL,
  "PRIVILEGE_NAME" VARCHAR2(50 BYTE),
  "PRIVILEGE_TYPE" NUMBER,
  "PRIVILEGE_CODE" VARCHAR2(50 BYTE),
  "URI" VARCHAR2(200 BYTE),
  "PARENT_ID" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_PRIVILEGE"."PRIVILEGE_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_PRIVILEGE"."PRIVILEGE_NAME" IS '权限名称';
COMMENT ON COLUMN "JACK"."TB_PRIVILEGE"."PRIVILEGE_TYPE" IS '权限类型 0菜单 1按钮';
COMMENT ON COLUMN "JACK"."TB_PRIVILEGE"."PRIVILEGE_CODE" IS '权限的唯一代码';
COMMENT ON COLUMN "JACK"."TB_PRIVILEGE"."URI" IS '权限资源的URI';
COMMENT ON COLUMN "JACK"."TB_PRIVILEGE"."PARENT_ID" IS '按钮所属的父Id（菜单的PRIVILEGE_ID）';

-- ----------------------------
-- Table structure for TB_QDSXJ
-- ----------------------------

CREATE TABLE "JACK"."TB_QDSXJ" (
  "SB_ID" NUMBER NOT NULL,
  "SB_BM" VARCHAR2(50 BYTE),
  "SB_NAME" VARCHAR2(200 BYTE),
  "SB_DWNAME" VARCHAR2(200 BYTE),
  "SB_FACTROY" VARCHAR2(50 BYTE),
  "SB_XH" VARCHAR2(50 BYTE),
  "SB_XZQY" VARCHAR2(50 BYTE),
  "SB_AZDZ" VARCHAR2(200 BYTE),
  "SB_JD" NUMBER(30,20),
  "SB_WD" NUMBER(30,20),
  "SB_IPV4" VARCHAR2(50 BYTE),
  "SB_IPV6" VARCHAR2(50 BYTE),
  "SB_DEVICEPTZTYPE" VARCHAR2(50 BYTE),
  "SB_GNTYPE" VARCHAR2(50 BYTE),
  "SB_WZTYPE" VARCHAR2(50 BYTE),
  "SB_BG" VARCHAR2(50 BYTE),
  "SB_FW" VARCHAR2(50 BYTE) DEFAULT NULL,
  "SB_FBL" VARCHAR2(50 BYTE),
  "SB_CODE" VARCHAR2(50 BYTE),
  "SB_LW" VARCHAR2(50 BYTE),
  "SB_SSJG" VARCHAR2(50 BYTE),
  "SB_SSBM" VARCHAR2(50 BYTE),
  "SB_BCSJ" VARCHAR2(50 BYTE),
  "SB_AZSJ" DATE,
  "SB_JSGD" VARCHAR2(50 BYTE),
  "SB_GLDW" VARCHAR2(50 BYTE),
  "SB_GLDWTEL" VARCHAR2(50 BYTE),
  "SB_YSZP" VARCHAR2(50 BYTE),
  "SB_STATE" VARCHAR2(50 BYTE),
  "SB_GXSJ" DATE,
  "SB_DK" VARCHAR2(50 BYTE),
  "SB_YWDW" VARCHAR2(200 BYTE),
  "SB_GLSB" VARCHAR2(50 BYTE),
  "SB_CCIP" VARCHAR2(50 BYTE),
  "SB_SSTYPE" VARCHAR2(50 BYTE),
  "SB_SSDW" VARCHAR2(50 BYTE),
  "SB_SSXT" NUMBER,
  "CORRECT_LONGITUDE" NUMBER(30,20),
  "CORRECT_LATITUDE" NUMBER(30,20),
  "ACCURATE_ADDRESS" VARCHAR2(255 BYTE),
  "ACCURATE_TOWNCODE" VARCHAR2(50 BYTE),
  "ACCURATE_TOWNNAME" VARCHAR2(50 BYTE),
  "MONITOR_TYPE" NUMBER,
  "CREATE_TIME" DATE DEFAULT SYSDATE,
  "UPDATE_TIME" DATE DEFAULT SYSDATE,
  "SB_TYPE" VARCHAR2(50 BYTE),
  "DEVICE_ID" VARCHAR2(100 BYTE),
  "DOMAIN_ID" VARCHAR2(100 BYTE),
  "EXPIRE_TIME" DATE,
  "SB_GLDWNAME" VARCHAR2(255 BYTE),
  "SB_WHRY" VARCHAR2(255 BYTE),
  "SB_CJRY" VARCHAR2(255 BYTE),
  "SB_CJRYTEL" VARCHAR2(255 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_ID" IS '设备主键';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_BM" IS '设备编码';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_NAME" IS '设备名称';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_DWNAME" IS '点位俗称';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_FACTROY" IS '设备厂商';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_XH" IS '设备型号';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_XZQY" IS '行政区域';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_AZDZ" IS '安装地址';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_JD" IS '矫正经度';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_WD" IS '矫正纬度';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_IPV4" IS 'IPV4';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_IPV6" IS 'IPV6';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_DEVICEPTZTYPE" IS '摄像机类型';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_GNTYPE" IS '摄像机功能类型';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_WZTYPE" IS '摄像机位置类型';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_BG" IS '摄像机补光属性';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_FW" IS '监视方位';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_FBL" IS '最高分辨率';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_CODE" IS '摄像机编码格式';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_LW" IS '联网属性';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_SSJG" IS '所属辖区公安机关';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_SSBM" IS '所属部门/行业';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_BCSJ" IS '录像保存时间(小时)';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_AZSJ" IS '安装时间';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_JSGD" IS '架设高度';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_GLDW" IS '管理单位';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_GLDWTEL" IS '管理单位联系方式';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_YSZP" IS '摄像机场景预设照片：URL';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_STATE" IS '设备状态';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_GXSJ" IS '属性更新时间';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_DK" IS '设备端口';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_YWDW" IS '运维单位';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_GLSB" IS '关联设备';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_CCIP" IS '对应存储设备IP';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_SSTYPE" IS '设备所属类型';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_SSDW" IS '摄像机所属点位';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_SSXT" IS '摄像机所属系统';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."CORRECT_LONGITUDE" IS '原始经度';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."CORRECT_LATITUDE" IS '原始纬度';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."ACCURATE_ADDRESS" IS '原始经纬度参考地址';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."ACCURATE_TOWNCODE" IS '参考街道行政编码';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."ACCURATE_TOWNNAME" IS '参考街道名称';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."MONITOR_TYPE" IS '监控区域类型 1-一类视频监控点 2-二类,3-三类,4-公安内部，9-其他';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_TYPE" IS '设备类型';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."DEVICE_ID" IS '设备Id';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."DOMAIN_ID" IS '域Id';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."EXPIRE_TIME" IS '设备到期时间';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_GLDWNAME" IS '管理单位名称';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_WHRY" IS '维护人员';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_CJRY" IS '采集人员';
COMMENT ON COLUMN "JACK"."TB_QDSXJ"."SB_CJRYTEL" IS '采集人员联系方式';

-- ----------------------------
-- Table structure for TB_QRCODE
-- ----------------------------

CREATE TABLE "JACK"."TB_QRCODE" (
  "QR_ID" NUMBER NOT NULL,
  "QR_CODECONTENT" VARCHAR2(100 BYTE),
  "QR_CODEIMGFILESAVEDIR" VARCHAR2(100 BYTE),
  "QYBM" VARCHAR2(10 BYTE),
  "XH" VARCHAR2(10 BYTE),
  "XLXBM" VARCHAR2(10 BYTE),
  "QR_BM" VARCHAR2(30 BYTE),
  "QRID_MD5" VARCHAR2(100 BYTE),
  "CREATE_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_QRCODE"."QR_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_QRCODE"."QR_CODECONTENT" IS 'URL、文本内容';
COMMENT ON COLUMN "JACK"."TB_QRCODE"."QR_CODEIMGFILESAVEDIR" IS '保存二维码图片地址';
COMMENT ON COLUMN "JACK"."TB_QRCODE"."QYBM" IS '区域编码';
COMMENT ON COLUMN "JACK"."TB_QRCODE"."XH" IS '序号，8位且唯一';
COMMENT ON COLUMN "JACK"."TB_QRCODE"."XLXBM" IS '杆位小类型编码';
COMMENT ON COLUMN "JACK"."TB_QRCODE"."QR_BM" IS '二维码20位编码[8位中心编码-2位杆件小类型编码-8位序号]';
COMMENT ON COLUMN "JACK"."TB_QRCODE"."QRID_MD5" IS 'qrid对应的MD5加密串';
COMMENT ON COLUMN "JACK"."TB_QRCODE"."CREATE_TIME" IS '二维码创建时间';

-- ----------------------------
-- Table structure for TB_ROLE
-- ----------------------------

CREATE TABLE "JACK"."TB_ROLE" (
  "ROLE_ID" NUMBER NOT NULL,
  "ROLE_NAME" VARCHAR2(50 BYTE),
  "STATUS" VARCHAR2(10 BYTE),
  "CREATE_BY" VARCHAR2(50 BYTE),
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(50 BYTE),
  "UPDATE_TIME" DATE,
  "REMARK" VARCHAR2(50 BYTE),
  "CLIENT_TYPE" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_ROLE"."ROLE_ID" IS '角色ID';
COMMENT ON COLUMN "JACK"."TB_ROLE"."ROLE_NAME" IS '1.管理员民警 2.办案民警 3.百姓 4.网格员';
COMMENT ON COLUMN "JACK"."TB_ROLE"."STATUS" IS '角色状态（0正常 1停用）';
COMMENT ON COLUMN "JACK"."TB_ROLE"."CREATE_BY" IS '创建者';
COMMENT ON COLUMN "JACK"."TB_ROLE"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JACK"."TB_ROLE"."UPDATE_BY" IS '更新者';
COMMENT ON COLUMN "JACK"."TB_ROLE"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "JACK"."TB_ROLE"."REMARK" IS '备注';

-- ----------------------------
-- Table structure for TB_ROLE_DATA_PRIVILEGE
-- ----------------------------

CREATE TABLE "JACK"."TB_ROLE_DATA_PRIVILEGE" (
  "RDP_ID" NUMBER NOT NULL,
  "ROLE_ID" NUMBER,
  "RESOURCE_CODE" VARCHAR2(20 BYTE),
  "RESOURCE_FIELD_CODE" VARCHAR2(50 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_ROLE_DATA_PRIVILEGE"."RDP_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_ROLE_DATA_PRIVILEGE"."ROLE_ID" IS '角色id';
COMMENT ON COLUMN "JACK"."TB_ROLE_DATA_PRIVILEGE"."RESOURCE_CODE" IS '资源代号，GW杆位，QDSXJ监控设备（前端摄像机），QRCODE二维码，WK工单';
COMMENT ON COLUMN "JACK"."TB_ROLE_DATA_PRIVILEGE"."RESOURCE_FIELD_CODE" IS '资源字段代号，XZQY行政区域';

-- ----------------------------
-- Table structure for TB_ROLE_PRIVILEGE
-- ----------------------------

CREATE TABLE "JACK"."TB_ROLE_PRIVILEGE" (
  "RP_ID" NUMBER NOT NULL,
  "ROLE_ID" NUMBER,
  "PRIVILEGE_ID" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_ROLE_PRIVILEGE"."RP_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_ROLE_PRIVILEGE"."ROLE_ID" IS '角色id';
COMMENT ON COLUMN "JACK"."TB_ROLE_PRIVILEGE"."PRIVILEGE_ID" IS '权限id';

-- ----------------------------
-- Table structure for TB_RZ
-- ----------------------------

CREATE TABLE "JACK"."TB_RZ" (
  "RZ_ID" NUMBER,
  "RZ_USER_ID" NUMBER,
  "RZ_TYPE" NUMBER,
  "RZ_MSG" VARCHAR2(255 CHAR),
  "RZ_TIME" DATE,
  "RZ_STATE" NUMBER,
  "RZ_URL_STATE" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_RZ"."RZ_ID" IS '日志ID';
COMMENT ON COLUMN "JACK"."TB_RZ"."RZ_USER_ID" IS '用户ID （0 用户不存在）';
COMMENT ON COLUMN "JACK"."TB_RZ"."RZ_TYPE" IS '操作类型：1新增 2修改 3删除 4详情';
COMMENT ON COLUMN "JACK"."TB_RZ"."RZ_MSG" IS '消息';
COMMENT ON COLUMN "JACK"."TB_RZ"."RZ_TIME" IS '操作时间';
COMMENT ON COLUMN "JACK"."TB_RZ"."RZ_STATE" IS '返回状态:0.正常 1.异常';
COMMENT ON COLUMN "JACK"."TB_RZ"."RZ_URL_STATE" IS '状态：1 前端 0 后端';

-- ----------------------------
-- Table structure for TB_SERVER_WORK
-- ----------------------------

CREATE TABLE "JACK"."TB_SERVER_WORK" (
  "SW_ID" NUMBER NOT NULL,
  "SW_REPORTER_ID" VARCHAR2(100 BYTE),
  "SW_REPORTER_NAME" VARCHAR2(100 BYTE),
  "SW_CONTENT" VARCHAR2(200 BYTE),
  "SW_PICID_1" VARCHAR2(100 BYTE),
  "SW_PICID_2" VARCHAR2(100 BYTE),
  "SW_PICID_3" VARCHAR2(100 BYTE),
  "SW_BC_ID" NUMBER,
  "SW_FAULT_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_SERVER_WORK"."SW_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_SERVER_WORK"."SW_REPORTER_ID" IS '上报人苏周到id';
COMMENT ON COLUMN "JACK"."TB_SERVER_WORK"."SW_REPORTER_NAME" IS '上报人姓名';
COMMENT ON COLUMN "JACK"."TB_SERVER_WORK"."SW_CONTENT" IS '工单内容';
COMMENT ON COLUMN "JACK"."TB_SERVER_WORK"."SW_PICID_1" IS '图片id1';
COMMENT ON COLUMN "JACK"."TB_SERVER_WORK"."SW_PICID_2" IS '图片id2';
COMMENT ON COLUMN "JACK"."TB_SERVER_WORK"."SW_PICID_3" IS '图片id3';
COMMENT ON COLUMN "JACK"."TB_SERVER_WORK"."SW_BC_ID" IS '条形码id';
COMMENT ON COLUMN "JACK"."TB_SERVER_WORK"."SW_FAULT_TIME" IS '上报时间';

-- ----------------------------
-- Table structure for TB_SP_GRANT
-- ----------------------------

CREATE TABLE "JACK"."TB_SP_GRANT" (
  "SP_GRANT_ID" NUMBER NOT NULL,
  "SP_GRANT_SQ_USER_ID" NUMBER,
  "SP_GRANT_SB_ID" NUMBER,
  "SP_GRANT_START" DATE,
  "SP_GRANT_END" DATE,
  "SP_GRANT_PZ_USER_ID" NUMBER,
  "SP_GRANT_GW_ID" NUMBER,
  "WK_ID" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_SP_GRANT"."SP_GRANT_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_SP_GRANT"."SP_GRANT_SQ_USER_ID" IS '申请人id';
COMMENT ON COLUMN "JACK"."TB_SP_GRANT"."SP_GRANT_SB_ID" IS '申请的设备id';
COMMENT ON COLUMN "JACK"."TB_SP_GRANT"."SP_GRANT_START" IS '申请时间段-开始时间';
COMMENT ON COLUMN "JACK"."TB_SP_GRANT"."SP_GRANT_END" IS '申请时间段-结束时间';
COMMENT ON COLUMN "JACK"."TB_SP_GRANT"."SP_GRANT_PZ_USER_ID" IS '批准人id--废弃';
COMMENT ON COLUMN "JACK"."TB_SP_GRANT"."SP_GRANT_GW_ID" IS '申请的设备所属的杆位id';
COMMENT ON COLUMN "JACK"."TB_SP_GRANT"."WK_ID" IS '关联工单ID，工单表主键';

-- ----------------------------
-- Table structure for TB_SP_GRANT_VIEW_TIME_SPAN
-- ----------------------------

CREATE TABLE "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN" (
  "TS_ID" NUMBER NOT NULL,
  "SP_GRANT_ID" NUMBER NOT NULL,
  "TIME_SPAN_START" DATE,
  "TIME_SPAN_END" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN"."TS_ID" IS '主键ID';
COMMENT ON COLUMN "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN"."SP_GRANT_ID" IS '临时视频权限申请表ID';
COMMENT ON COLUMN "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN"."TIME_SPAN_START" IS '查看时间段起始时间';
COMMENT ON COLUMN "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN"."TIME_SPAN_END" IS '查看时间段结束时间';

-- ----------------------------
-- Table structure for TB_TEMP_USER
-- ----------------------------

CREATE TABLE "JACK"."TB_TEMP_USER" (
  "TMP_USER_ID" NUMBER NOT NULL,
  "TEMP_USER_NAME" VARCHAR2(50 BYTE),
  "TEMP_USER_PASSWORD" VARCHAR2(50 BYTE),
  "LOCKED" NUMBER,
  "EXPIRE_DATE" DATE,
  "USER_NAME" VARCHAR2(20 BYTE),
  "USER_PHONE" VARCHAR2(12 BYTE),
  "IDENTITY" VARCHAR2(18 BYTE),
  "USER_TYPE" NUMBER(1,0),
  "TEAM_NAME" VARCHAR2(50 BYTE),
  "TEAM_CODE" VARCHAR2(50 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_TEMP_USER"."TMP_USER_ID" IS '主键ID';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER"."TEMP_USER_NAME" IS '临时用户登录名称';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER"."TEMP_USER_PASSWORD" IS '临时用户登录密码';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER"."LOCKED" IS '1锁定 0正常';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER"."EXPIRE_DATE" IS '过期时间';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER"."TEAM_NAME" IS '用户所属队名，如“裴老板队”';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER"."TEAM_CODE" IS '用户所属队名编码, 如“裴老板队”对应pt，张班长队对应af';

-- ----------------------------
-- Table structure for TB_TEMP_USER_BIND_JKGW
-- ----------------------------

CREATE TABLE "JACK"."TB_TEMP_USER_BIND_JKGW" (
  "TUBJ_ID" NUMBER NOT NULL,
  "TMP_USER_ID" NUMBER,
  "QRID_MD5" VARCHAR2(200 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_BIND_JKGW"."TMP_USER_ID" IS '临时用户id';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_BIND_JKGW"."QRID_MD5" IS '二维码md5';
COMMENT ON TABLE "JACK"."TB_TEMP_USER_BIND_JKGW" IS '临时用户与杆位绑定关系';

-- ----------------------------
-- Table structure for TB_TEMP_USER_EQUIP_PRIVILEGE
-- ----------------------------

CREATE TABLE "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE" (
  "RUEP_ID" NUMBER NOT NULL,
  "TMP_USER_ID" NUMBER,
  "PRIVILEGE_NAME" VARCHAR2(255 BYTE),
  "LEFT_TOP_LONGITUDE" NUMBER(30,20),
  "LEFT_TOP_LATITUDE" NUMBER(30,20),
  "RIGHT_BOTTOM_LONGITUDE" NUMBER(30,20),
  "RIGHT_BOTTOM_LATITUDE" NUMBER(30,20)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE"."RUEP_ID" IS '主键，自增';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE"."TMP_USER_ID" IS '临时用户id';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE"."PRIVILEGE_NAME" IS '权限名称，如‘干将西路以北设备查看权限’';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE"."LEFT_TOP_LONGITUDE" IS '矩形区域左上角经度';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE"."LEFT_TOP_LATITUDE" IS '矩形区域左上角纬度';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE"."RIGHT_BOTTOM_LONGITUDE" IS '矩形区域右下角经度';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE"."RIGHT_BOTTOM_LATITUDE" IS '矩形区域右下角纬度';

-- ----------------------------
-- Table structure for TB_TEMP_USER_HISTORIC_POSITION
-- ----------------------------

CREATE TABLE "JACK"."TB_TEMP_USER_HISTORIC_POSITION" (
  "RT_ID" NUMBER,
  "LONGITUDE" NUMBER(30,20),
  "LATITUDE" NUMBER(30,20),
  "CURRENT_TIME" DATE,
  "CURRENT_ADDRESS" VARCHAR2(500 BYTE),
  "TMP_USER_ID" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_HISTORIC_POSITION"."LONGITUDE" IS '经度';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_HISTORIC_POSITION"."LATITUDE" IS '纬度';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_HISTORIC_POSITION"."CURRENT_TIME" IS '当前上传经纬度的时间';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_HISTORIC_POSITION"."CURRENT_ADDRESS" IS '当前经纬度对应的地址';
COMMENT ON COLUMN "JACK"."TB_TEMP_USER_HISTORIC_POSITION"."TMP_USER_ID" IS '临时用户id索引';

-- ----------------------------
-- Table structure for TB_TEST_QDSXJ
-- ----------------------------

CREATE TABLE "JACK"."TB_TEST_QDSXJ" (
  "SB_ID" NUMBER NOT NULL,
  "SB_BM" VARCHAR2(50 BYTE),
  "SB_NAME" VARCHAR2(200 BYTE),
  "SB_DWNAME" VARCHAR2(200 BYTE),
  "SB_FACTROY" VARCHAR2(50 BYTE),
  "SB_XH" VARCHAR2(50 BYTE),
  "SB_XZQY" VARCHAR2(50 BYTE),
  "SB_AZDZ" VARCHAR2(200 BYTE),
  "SB_JD" VARCHAR2(50 BYTE),
  "SB_WD" VARCHAR2(50 BYTE),
  "SB_IPV4" VARCHAR2(50 BYTE),
  "SB_IPV6" VARCHAR2(50 BYTE),
  "SB_DEVICEPTZTYPE" VARCHAR2(50 BYTE),
  "SB_GNTYPE" VARCHAR2(50 BYTE),
  "SB_WZTYPE" VARCHAR2(50 BYTE),
  "SB_BG" VARCHAR2(50 BYTE),
  "SB_FW" VARCHAR2(50 BYTE),
  "SB_FBL" VARCHAR2(50 BYTE),
  "SB_CODE" VARCHAR2(50 BYTE),
  "SB_LW" VARCHAR2(50 BYTE),
  "SB_SSJG" VARCHAR2(50 BYTE),
  "SB_SSBM" VARCHAR2(50 BYTE),
  "SB_BCSJ" VARCHAR2(50 BYTE),
  "SB_AZSJ" DATE,
  "SB_JSGD" VARCHAR2(50 BYTE),
  "SB_GLDW" VARCHAR2(50 BYTE),
  "SB_GLDWTEL" VARCHAR2(50 BYTE),
  "SB_YSZP" VARCHAR2(50 BYTE),
  "SB_STATE" VARCHAR2(50 BYTE),
  "SB_GXSJ" DATE,
  "SB_DK" VARCHAR2(50 BYTE),
  "SB_YWDW" VARCHAR2(200 BYTE),
  "SB_GLSB" VARCHAR2(50 BYTE),
  "SB_CCIP" VARCHAR2(50 BYTE),
  "SB_SSTYPE" VARCHAR2(50 BYTE),
  "SB_SSDW" VARCHAR2(50 BYTE),
  "SB_SSXT" NUMBER,
  "CORRECT_LONGITUDE" NUMBER(30,20),
  "CORRECT_LATITUDE" NUMBER(30,20),
  "ACCURATE_ADDRESS" VARCHAR2(255 BYTE),
  "ACCURATE_TOWNCODE" VARCHAR2(50 BYTE),
  "ACCURATE_TOWNNAME" VARCHAR2(50 BYTE),
  "MONITOR_TYPE" NUMBER,
  "CREATE_TIME" DATE,
  "UPDATE_TIME" DATE,
  "SB_TYPE" VARCHAR2(50 BYTE),
  "DEVICE_ID" VARCHAR2(100 BYTE),
  "DOMAIN_ID" VARCHAR2(100 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_ID" IS '设备主键';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_BM" IS '设备编码';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_NAME" IS '设备名称';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_DWNAME" IS '点位俗称';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_FACTROY" IS '设备厂商';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_XH" IS '设备型号';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_XZQY" IS '行政区域';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_AZDZ" IS '安装地址';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_JD" IS '矫正经度';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_WD" IS '矫正纬度';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_IPV4" IS 'IPV4';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_IPV6" IS 'IPV6';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_DEVICEPTZTYPE" IS '摄像机类型';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_GNTYPE" IS '摄像机功能类型';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_WZTYPE" IS '摄像机位置类型';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_BG" IS '摄像机补光属性';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_FW" IS '监视方位';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_FBL" IS '最高分辨率';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_CODE" IS '摄像机编码格式';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_LW" IS '联网属性';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_SSJG" IS '所属辖区公安机关';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_SSBM" IS '所属部门/行业';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_BCSJ" IS '录像保存时间(小时)';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_AZSJ" IS '安装时间';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_JSGD" IS '架设高度';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_GLDW" IS '管理单位';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_GLDWTEL" IS '管理单位联系方式';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_YSZP" IS '摄像机场景预设照片：URL';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_STATE" IS '设备状态';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_GXSJ" IS '属性更新时间';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_DK" IS '设备端口';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_YWDW" IS '运维单位';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_GLSB" IS '关联设备';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_CCIP" IS '对应存储设备IP';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_SSTYPE" IS '设备所属类型';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_SSDW" IS '摄像机所属点位';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_SSXT" IS '摄像机所属系统';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."CORRECT_LONGITUDE" IS '原始经度';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."CORRECT_LATITUDE" IS '原始纬度';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."ACCURATE_ADDRESS" IS '原始经纬度参考地址';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."ACCURATE_TOWNCODE" IS '参考街道行政编码';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."ACCURATE_TOWNNAME" IS '参考街道名称';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."MONITOR_TYPE" IS '监控区域类型 1-一类视频监控点 2-二类,3-三类,4-公安内部，9-其他';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."SB_TYPE" IS '设备类型';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."DEVICE_ID" IS '设备Id';
COMMENT ON COLUMN "JACK"."TB_TEST_QDSXJ"."DOMAIN_ID" IS '域Id';

-- ----------------------------
-- Table structure for TB_THIRD_PLATFORM_USER
-- ----------------------------

CREATE TABLE "JACK"."TB_THIRD_PLATFORM_USER" (
  "TPU_ID" NUMBER NOT NULL,
  "PLATFORM_CODE" VARCHAR2(30 BYTE),
  "PLATFORM_USER_ID" VARCHAR2(30 BYTE),
  "PLATFORM_UNION_ID" VARCHAR2(30 BYTE),
  "DISPLAY_NAME" VARCHAR2(30 BYTE),
  "CREATE_TIME" DATE,
  "UPDATE_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_THIRD_PLATFORM_USER"."TPU_ID" IS '主键';
COMMENT ON COLUMN "JACK"."TB_THIRD_PLATFORM_USER"."PLATFORM_CODE" IS '第三方平台类型，WECHATPUBLIC微信公众号，WECHATMINI，微信小程序，SUZHOUDAO苏周到';
COMMENT ON COLUMN "JACK"."TB_THIRD_PLATFORM_USER"."PLATFORM_USER_ID" IS '第三方平台的用户ID，如微信公众号的opoenid';
COMMENT ON COLUMN "JACK"."TB_THIRD_PLATFORM_USER"."PLATFORM_UNION_ID" IS '第三方平台的统一用户ID，如微信公众号的unionid，苏周到的身份证号';
COMMENT ON COLUMN "JACK"."TB_THIRD_PLATFORM_USER"."DISPLAY_NAME" IS '用户在第三方平台上的名称';
COMMENT ON COLUMN "JACK"."TB_THIRD_PLATFORM_USER"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JACK"."TB_THIRD_PLATFORM_USER"."UPDATE_TIME" IS '更新时间';

-- ----------------------------
-- Table structure for TB_USER
-- ----------------------------

CREATE TABLE "JACK"."TB_USER" (
  "USER_ID" NUMBER NOT NULL,
  "LOGIN_USER_NAME" VARCHAR2(50 BYTE),
  "LOGIN_PASSWORD" VARCHAR2(200 BYTE),
  "NICK_NAME" VARCHAR2(50 BYTE),
  "LOCKED" NUMBER,
  "ROLE_ID" NUMBER,
  "EMPLOYEE_NO" VARCHAR2(10 BYTE),
  "USER_TYPE" NUMBER,
  "IMAGE_NAME" VARCHAR2(50 BYTE),
  "CREATE_BY" VARCHAR2(30 BYTE),
  "CREATE_TIME" DATE,
  "UPDATE_BY" VARCHAR2(30 BYTE),
  "UPDATE_TIME" DATE,
  "USER_AREA" VARCHAR2(50 BYTE),
  "ID_NO" VARCHAR2(100 BYTE),
  "WORK_UNIT_NAME" VARCHAR2(100 BYTE),
  "WORK_UNIT_CODE" VARCHAR2(100 BYTE),
  "EMAIL" VARCHAR2(255 BYTE),
  "MOBILE" VARCHAR2(255 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_USER"."USER_ID" IS '用户ID';
COMMENT ON COLUMN "JACK"."TB_USER"."LOGIN_USER_NAME" IS '登录名称';
COMMENT ON COLUMN "JACK"."TB_USER"."LOGIN_PASSWORD" IS '登录密码';
COMMENT ON COLUMN "JACK"."TB_USER"."NICK_NAME" IS '昵称';
COMMENT ON COLUMN "JACK"."TB_USER"."LOCKED" IS '1锁定 0正常';
COMMENT ON COLUMN "JACK"."TB_USER"."ROLE_ID" IS '角色ID --废弃';
COMMENT ON COLUMN "JACK"."TB_USER"."USER_TYPE" IS '用户类型，0 保留用户，1管理员，2民警';
COMMENT ON COLUMN "JACK"."TB_USER"."IMAGE_NAME" IS '用户照片文件名，路径由程序读取配置';
COMMENT ON COLUMN "JACK"."TB_USER"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "JACK"."TB_USER"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "JACK"."TB_USER"."UPDATE_BY" IS '更新人';
COMMENT ON COLUMN "JACK"."TB_USER"."UPDATE_TIME" IS '更新时间';
COMMENT ON COLUMN "JACK"."TB_USER"."USER_AREA" IS '用户所属行政区域（民警属性）';
COMMENT ON COLUMN "JACK"."TB_USER"."ID_NO" IS '身份证号';
COMMENT ON COLUMN "JACK"."TB_USER"."WORK_UNIT_NAME" IS '用户单位（部门）名称';
COMMENT ON COLUMN "JACK"."TB_USER"."WORK_UNIT_CODE" IS '用户单位（部门）代码';
COMMENT ON COLUMN "JACK"."TB_USER"."EMAIL" IS '邮箱';
COMMENT ON COLUMN "JACK"."TB_USER"."MOBILE" IS '手机号';

-- ----------------------------
-- Table structure for TB_USERGROUP
-- ----------------------------

CREATE TABLE "JACK"."TB_USERGROUP" (
  "UG_ID" NUMBER NOT NULL,
  "USERGROUP_NAME" VARCHAR2(30 BYTE),
  "REMARK" VARCHAR2(200 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_USERGROUP"."UG_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_USERGROUP"."USERGROUP_NAME" IS '用户组名称';
COMMENT ON COLUMN "JACK"."TB_USERGROUP"."REMARK" IS '备注';

-- ----------------------------
-- Table structure for TB_USERGROUP_ROLE
-- ----------------------------

CREATE TABLE "JACK"."TB_USERGROUP_ROLE" (
  "UGR_ID" NUMBER NOT NULL,
  "ROLE_ID" NUMBER,
  "USERGROUP_ID" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_USERGROUP_ROLE"."UGR_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_USERGROUP_ROLE"."ROLE_ID" IS '角色id';
COMMENT ON COLUMN "JACK"."TB_USERGROUP_ROLE"."USERGROUP_ID" IS '用户组id';

-- ----------------------------
-- Table structure for TB_USERGROUP_USER
-- ----------------------------

CREATE TABLE "JACK"."TB_USERGROUP_USER" (
  "UGU_ID" NUMBER NOT NULL,
  "USER_ID" NUMBER,
  "USERGROUP_ID" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_USERGROUP_USER"."UGU_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_USERGROUP_USER"."USER_ID" IS '用户id';
COMMENT ON COLUMN "JACK"."TB_USERGROUP_USER"."USERGROUP_ID" IS '用户组id';

-- ----------------------------
-- Table structure for TB_USERTYPE_DATA_PRIVILEGE
-- ----------------------------

CREATE TABLE "JACK"."TB_USERTYPE_DATA_PRIVILEGE" (
  "UTDP_ID" NUMBER NOT NULL,
  "USER_TYPE" NUMBER,
  "RESOURCE_CODE" VARCHAR2(20 BYTE),
  "RESOURCE_FIELD_CODE" VARCHAR2(50 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_USERTYPE_DATA_PRIVILEGE"."UTDP_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_USERTYPE_DATA_PRIVILEGE"."USER_TYPE" IS '用户类型，0 管理员，1民警，2网格人员，3运维人员，4普通百姓 ';
COMMENT ON COLUMN "JACK"."TB_USERTYPE_DATA_PRIVILEGE"."RESOURCE_CODE" IS '资源代号，GW杆位，QDSXJ监控设备（前端摄像机），QRCODE二维码，WK工单';
COMMENT ON COLUMN "JACK"."TB_USERTYPE_DATA_PRIVILEGE"."RESOURCE_FIELD_CODE" IS '资源字段代号，XZQY行政区域';

-- ----------------------------
-- Table structure for TB_USER_MESSAGE
-- ----------------------------

CREATE TABLE "JACK"."TB_USER_MESSAGE" (
  "user_msg_id" NUMBER NOT NULL,
  "user_id" NUMBER,
  "wk_id" NUMBER,
  "user_read" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_USER_MESSAGE"."user_id" IS '用户id';
COMMENT ON COLUMN "JACK"."TB_USER_MESSAGE"."wk_id" IS '工单id';
COMMENT ON COLUMN "JACK"."TB_USER_MESSAGE"."user_read" IS '是否已读 0：未读 ， 1：已读';

-- ----------------------------
-- Table structure for TB_USER_ROLE
-- ----------------------------

CREATE TABLE "JACK"."TB_USER_ROLE" (
  "UR_ID" NUMBER NOT NULL,
  "ROLE_ID" NUMBER,
  "USER_ID" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_USER_ROLE"."UR_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_USER_ROLE"."ROLE_ID" IS '角色id';
COMMENT ON COLUMN "JACK"."TB_USER_ROLE"."USER_ID" IS '用户id';

-- ----------------------------
-- Table structure for TB_WORK
-- ----------------------------

CREATE TABLE "JACK"."TB_WORK" (
  "WK_ID" NUMBER NOT NULL,
  "WK_TYPE" NUMBER,
  "WK_SQ_USER_ID" NUMBER,
  "WK_CONTENT" VARCHAR2(100 BYTE),
  "WK_GW_ID" NUMBER,
  "WK_SB_ID" NUMBER,
  "WK_SQ_TIME" DATE,
  "WK_STATE" NUMBER DEFAULT 0,
  "WK_SP_USER_ID" NUMBER,
  "WK_SP_TIME" DATE,
  "WK_PPCITURE_1" VARCHAR2(50 BYTE),
  "WK_PPCITURE_2" VARCHAR2(50 BYTE),
  "WK_PPCITURE_3" VARCHAR2(50 BYTE),
  "WK_AREA_CODE" VARCHAR2(30 BYTE),
  "FAULT_TYPE" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_ID" IS '工单id';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_TYPE" IS '工单类型';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_SQ_USER_ID" IS '申请人id';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_CONTENT" IS '工单内容';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_GW_ID" IS '杆件id';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_SB_ID" IS '设备id';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_SQ_TIME" IS '申请时间
';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_STATE" IS '工单状态（0 审批中，1 审批通过，2审批驳回）';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_SP_USER_ID" IS '当前审批人id';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_SP_TIME" IS '审批时间';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_PPCITURE_1" IS '图片id1';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_PPCITURE_2" IS '图片id2';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_PPCITURE_3" IS '图片id3';
COMMENT ON COLUMN "JACK"."TB_WORK"."WK_AREA_CODE" IS '申请区域行政编码';
COMMENT ON COLUMN "JACK"."TB_WORK"."FAULT_TYPE" IS '故障类型';

-- ----------------------------
-- Table structure for TB_WORK_DEVICE_DATE
-- ----------------------------

CREATE TABLE "JACK"."TB_WORK_DEVICE_DATE" (
  "WORK_DEVICE_ID" NUMBER NOT NULL,
  "WORK_DEVICE_PATH" VARCHAR2(200 BYTE),
  "WORK_DEVICE_NAME" VARCHAR2(200 BYTE),
  "WORK_DEVICE_DATE" DATE,
  "WORK_DEVICE_TYPE" NUMBER(2,0)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_WORK_DEVICE_DATE"."WORK_DEVICE_TYPE" IS '1:表示工单 0:表示视频';

-- ----------------------------
-- Table structure for TB_WORK_SP_CONFIG
-- ----------------------------

CREATE TABLE "JACK"."TB_WORK_SP_CONFIG" (
  "WKCFG_ID" NUMBER NOT NULL,
  "WK_TYPE" NUMBER,
  "WK_SEQUENCE" NUMBER,
  "USER_ID" NUMBER
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_WORK_SP_CONFIG"."WKCFG_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_WORK_SP_CONFIG"."WK_TYPE" IS '工单类型，同工单表的WK_TYPE';
COMMENT ON COLUMN "JACK"."TB_WORK_SP_CONFIG"."WK_SEQUENCE" IS '工单审批顺序';
COMMENT ON COLUMN "JACK"."TB_WORK_SP_CONFIG"."USER_ID" IS '审批人id';

-- ----------------------------
-- Table structure for TB_WORK_SP_HISTORY
-- ----------------------------

CREATE TABLE "JACK"."TB_WORK_SP_HISTORY" (
  "WKHIS_ID" NUMBER NOT NULL,
  "WK_ID" NUMBER,
  "WK_SEQUENCE" NUMBER,
  "SP_USER_ID" NUMBER,
  "WK_SP_RESULT" NUMBER,
  "WK_SP_TIME" DATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_WORK_SP_HISTORY"."WKHIS_ID" IS '主键id';
COMMENT ON COLUMN "JACK"."TB_WORK_SP_HISTORY"."WK_ID" IS '工单id';
COMMENT ON COLUMN "JACK"."TB_WORK_SP_HISTORY"."WK_SEQUENCE" IS '审批顺序';
COMMENT ON COLUMN "JACK"."TB_WORK_SP_HISTORY"."SP_USER_ID" IS '审批人id';
COMMENT ON COLUMN "JACK"."TB_WORK_SP_HISTORY"."WK_SP_RESULT" IS '审批结果（1通过，2驳回）';
COMMENT ON COLUMN "JACK"."TB_WORK_SP_HISTORY"."WK_SP_TIME" IS '审批时间';

-- ----------------------------
-- Table structure for TB_YJYD
-- ----------------------------

CREATE TABLE "JACK"."TB_YJYD" (
  "YJ_ID" NUMBER NOT NULL,
  "YJ_JK_ID" NUMBER,
  "YJ_CODE" VARCHAR2(50 BYTE),
  "YJ_DWNAME" VARCHAR2(50 BYTE),
  "YJ_ADDRESS" VARCHAR2(50 BYTE),
  "YJ_WL" VARCHAR2(50 BYTE),
  "YJ_LW" VARCHAR2(50 BYTE),
  "YJ_GB" VARCHAR2(50 BYTE),
  "YJ_ZQ" VARCHAR2(50 BYTE),
  "YJ_LXR" VARCHAR2(50 BYTE),
  "YJ_LXDH" VARCHAR2(50 BYTE),
  "YJ_DWDZ" VARCHAR2(50 BYTE),
  "YJ_HY" VARCHAR2(50 BYTE),
  "YJ_TYPE" VARCHAR2(50 BYTE),
  "YJ_NUMBER" NUMBER,
  "YJ_JD" VARCHAR2(50 BYTE),
  "YJ_WD" VARCHAR2(50 BYTE),
  "YJ_JK" VARCHAR2(100 BYTE),
  "YJ_JKFW" VARCHAR2(50 BYTE),
  "YJ_GDXX" VARCHAR2(50 BYTE)
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_ID" IS '监控系统编号';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_JK_ID" IS '监控系统名称';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_CODE" IS '管理单位代码';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_DWNAME" IS '管理单位名称';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_ADDRESS" IS '监控系统所在地';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_WL" IS '承载网络';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_LW" IS '是否联网';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_GB" IS '是否符合国标';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_ZQ" IS '录像存储周期';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_LXR" IS '联系人';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_LXDH" IS '联系电话';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_DWDZ" IS '单位地址';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_HY" IS '所属行业';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_TYPE" IS '系统所属类型';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_NUMBER" IS '监控系统摄像机数量';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_JD" IS '监控系统所在位置经度';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_WD" IS '监控系统所在位置纬度';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_JK" IS '系统接口';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_JKFW" IS '系统监控范围';
COMMENT ON COLUMN "JACK"."TB_YJYD"."YJ_GDXX" IS '已归档的设备信息';

-- ----------------------------
-- Table structure for TOPWALK_DTP_276650610_TB
-- ----------------------------

CREATE TABLE "JACK"."TOPWALK_DTP_276650610_TB" (
  "ACTION_ID" NUMBER(30,0) NOT NULL,
  "TASK_NAME" VARCHAR2(100 BYTE) NOT NULL,
  "ACTION_OBJECT" VARCHAR2(50 BYTE) NOT NULL,
  "ACTION_NAME" VARCHAR2(10 BYTE) NOT NULL,
  "ACTION_PRIMARYKEY" VARCHAR2(2000 BYTE) NOT NULL,
  "ACTION_OLDPRIMARYKEY" VARCHAR2(2000 BYTE),
  "ACTION_ERROR" NUMBER(30,0) DEFAULT 0,
  "ACTION_DATE" DATE DEFAULT SYSDATE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Table structure for TOPWALK_DTP_SELECT_TB
-- ----------------------------

CREATE TABLE "JACK"."TOPWALK_DTP_SELECT_TB" (
  "ID" NUMBER NOT NULL,
  "TABLE_NAME" VARCHAR2(100 BYTE) NOT NULL,
  "TABLE_TASK" VARCHAR2(200 BYTE),
  "TABLE_EVER" NUMBER(5,0),
  "ACTION_STATE" NUMBER(5,0) DEFAULT 0
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Sequence structure for SEQ_BC_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_BC_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_BC_XH
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_BC_XH" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_DEVICE_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_DEVICE_ID" MINVALUE 1 MAXVALUE 9999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_DICTDATA_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_DICTDATA_ID" MINVALUE 113 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_DICTTYPE_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_DICTTYPE_ID" MINVALUE 24 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_EBW_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_EBW_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_EQUIP_BINDING_WORK_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_EQUIP_BINDING_WORK_ID" MINVALUE 10 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_EQ_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_EQ_ID" MINVALUE 10 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_EWW_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_EWW_ID" MINVALUE 1 MAXVALUE 9999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_GW_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_GW_ID" MINVALUE 62 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_IOPICDBLINK_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_IOPICDBLINK_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_IO_PIC_DBLINK
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_IO_PIC_DBLINK" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_IVSCAMERA_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_IVSCAMERA_ID" MINVALUE 1 MAXVALUE 99999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_JK_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_JK_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_OP_WORK_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_OP_WORK_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_PQBH_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_PQBH_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_PRIVILEGE_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_PRIVILEGE_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_QDSXJ_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_QDSXJ_ID" MINVALUE 10 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_QR_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_QR_ID" MINVALUE 452 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_ROLE_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_ROLE_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_ROLE_PRIVILEGE_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_ROLE_PRIVILEGE_ID" MINVALUE 10 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_RZ_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_RZ_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_SP_GRANT_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_SP_GRANT_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_SW_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_SW_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_TB_EARLY_WARNING
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_TB_EARLY_WARNING" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_TEMPUSER_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_TEMPUSER_ID" MINVALUE 10 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_TEMP_USER_BIND_JKG
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_TEMP_USER_BIND_JKG" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_TEMP_USER_EQUIP_PRIVILEGE
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_TEMP_USER_EQUIP_PRIVILEGE" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_THIRD_PLATFORM_USER_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_THIRD_PLATFORM_USER_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_USERGROUP_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_USERGROUP_ID" MINVALUE 10 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_USERGROUP_ROLE_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_USERGROUP_ROLE_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_USERGROUP_USER_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_USERGROUP_USER_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_USERTYPE_DATA_PRIVILEGE_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_USERTYPE_DATA_PRIVILEGE_ID" MINVALUE 10 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_USER_HISTORIC_POSITION
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_USER_HISTORIC_POSITION" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_USER_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_USER_ID" MINVALUE 89 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_USER_MSG_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_USER_MSG_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_USER_ROLE_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_USER_ROLE_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_VIEW_TIME_SPAN_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_VIEW_TIME_SPAN_ID" MINVALUE 1 MAXVALUE 99999999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_WKCFG_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_WKCFG_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_WK_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_WK_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_WORK_SP_HISTORY_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_WORK_SP_HISTORY_ID" MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for SEQ_XH
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_XH" MINVALUE 1000000 MAXVALUE 9999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for SEQ_YJ_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."SEQ_YJ_ID" MINVALUE 4 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for TOPWALK_SEQUENCE_ID
-- ----------------------------

CREATE SEQUENCE "JACK"."TOPWALK_SEQUENCE_ID" MINVALUE 1 MAXVALUE 99999999999999999999 INCREMENT BY 1 CYCLE CACHE 20;

-- ----------------------------
-- Primary Key structure for table IO_PIC_DBLINK
-- ----------------------------
ALTER TABLE "JACK"."IO_PIC_DBLINK" ADD CONSTRAINT "SYS_C0011663" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table IO_PIC_DBLINK
-- ----------------------------
ALTER TABLE "JACK"."IO_PIC_DBLINK" ADD CONSTRAINT "SYS_C0014676" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."IO_PIC_DBLINK" ADD CONSTRAINT "SYS_C0017773" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_BARCODE
-- ----------------------------
ALTER TABLE "JACK"."TB_BARCODE" ADD CONSTRAINT "SYS_C0014666" PRIMARY KEY ("BC_ID");

-- ----------------------------
-- Checks structure for table TB_BARCODE
-- ----------------------------
ALTER TABLE "JACK"."TB_BARCODE" ADD CONSTRAINT "SYS_C0014665" CHECK ("BC_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_BARCODE" ADD CONSTRAINT "SYS_C0017774" CHECK ("BC_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_BARCODE
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_51_I" AFTER INSERT ON "JACK"."TB_BARCODE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_BARCODE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_BARCODE"','276650610','insert',''''||:new."BC_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_52_U" AFTER UPDATE ON "JACK"."TB_BARCODE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_BARCODE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_BARCODE"','276650610','update',''''||:new."BC_ID"||'''',''''||:old."BC_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_53_D" AFTER DELETE ON "JACK"."TB_BARCODE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_BARCODE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_BARCODE"','276650610','delete',''''||:old."BC_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_DEVICE_DATA
-- ----------------------------
ALTER TABLE "JACK"."TB_DEVICE_DATA" ADD CONSTRAINT "SYS_C0011580" PRIMARY KEY ("DEVICE_CODE_ID");

-- ----------------------------
-- Checks structure for table TB_DEVICE_DATA
-- ----------------------------
ALTER TABLE "JACK"."TB_DEVICE_DATA" ADD CONSTRAINT "SYS_C0011579" CHECK ("DEVICE_CODE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_DEVICE_DATA" ADD CONSTRAINT "SYS_C0017520" CHECK ("DEVICE_CODE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_DEVICE_DATA" ADD CONSTRAINT "SYS_C0017775" CHECK ("DEVICE_CODE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_DEVICE_STATUS
-- ----------------------------
ALTER TABLE "JACK"."TB_DEVICE_STATUS" ADD CONSTRAINT "SYS_C0011583" PRIMARY KEY ("DEVICE_CODE_ID");

-- ----------------------------
-- Checks structure for table TB_DEVICE_STATUS
-- ----------------------------
ALTER TABLE "JACK"."TB_DEVICE_STATUS" ADD CONSTRAINT "SYS_C0011582" CHECK ("DEVICE_CODE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_DEVICE_STATUS" ADD CONSTRAINT "SYS_C0017523" CHECK ("DEVICE_CODE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_DEVICE_STATUS" ADD CONSTRAINT "SYS_C0017776" CHECK ("DEVICE_CODE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_DICT_DATA
-- ----------------------------
ALTER TABLE "JACK"."TB_DICT_DATA" ADD CONSTRAINT "PK_CODE_ID" PRIMARY KEY ("DICT_CODE_ID");

-- ----------------------------
-- Checks structure for table TB_DICT_DATA
-- ----------------------------
ALTER TABLE "JACK"."TB_DICT_DATA" ADD CONSTRAINT "SYS_C0011050" CHECK ("DICT_CODE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_DICT_DATA" ADD CONSTRAINT "SYS_C0017777" CHECK ("DICT_CODE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_DICT_DATA
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_12_I" AFTER INSERT ON "JACK"."TB_DICT_DATA" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_DICT_DATA"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_DICT_DATA"','276650610','insert',''''||:new."DICT_CODE_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_13_U" AFTER UPDATE ON "JACK"."TB_DICT_DATA" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_DICT_DATA"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_DICT_DATA"','276650610','update',''''||:new."DICT_CODE_ID"||'''',''''||:old."DICT_CODE_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_14_D" AFTER DELETE ON "JACK"."TB_DICT_DATA" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_DICT_DATA"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_DICT_DATA"','276650610','delete',''''||:old."DICT_CODE_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_DICT_TYPE
-- ----------------------------
ALTER TABLE "JACK"."TB_DICT_TYPE" ADD CONSTRAINT "PK_DICT_ID" PRIMARY KEY ("DICT_ID");

-- ----------------------------
-- Uniques structure for table TB_DICT_TYPE
-- ----------------------------
ALTER TABLE "JACK"."TB_DICT_TYPE" ADD CONSTRAINT "UN_DICT_TYPE" UNIQUE ("DICT_TYPE") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table TB_DICT_TYPE
-- ----------------------------
ALTER TABLE "JACK"."TB_DICT_TYPE" ADD CONSTRAINT "SYS_C0011047" CHECK ("DICT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_DICT_TYPE" ADD CONSTRAINT "SYS_C0017778" CHECK ("DICT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_DICT_TYPE
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_63_I" AFTER INSERT ON "JACK"."TB_DICT_TYPE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_DICT_TYPE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_DICT_TYPE"','276650610','insert',''''||:new."DICT_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_64_U" AFTER UPDATE ON "JACK"."TB_DICT_TYPE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_DICT_TYPE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_DICT_TYPE"','276650610','update',''''||:new."DICT_ID"||'''',''''||:old."DICT_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_65_D" AFTER DELETE ON "JACK"."TB_DICT_TYPE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_DICT_TYPE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_DICT_TYPE"','276650610','delete',''''||:old."DICT_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_EARLY_WARNING
-- ----------------------------
ALTER TABLE "JACK"."TB_EARLY_WARNING" ADD CONSTRAINT "SYS_C0011598" PRIMARY KEY ("early_warning_id");

-- ----------------------------
-- Checks structure for table TB_EARLY_WARNING
-- ----------------------------
ALTER TABLE "JACK"."TB_EARLY_WARNING" ADD CONSTRAINT "SYS_C0014674" CHECK ("early_warning_id" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_EARLY_WARNING" ADD CONSTRAINT "SYS_C0017779" CHECK ("early_warning_id" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_EARLY_WARNING_WORK
-- ----------------------------
ALTER TABLE "JACK"."TB_EARLY_WARNING_WORK" ADD CONSTRAINT "SYS_C0016045" PRIMARY KEY ("EWW_ID");

-- ----------------------------
-- Checks structure for table TB_EARLY_WARNING_WORK
-- ----------------------------
ALTER TABLE "JACK"."TB_EARLY_WARNING_WORK" ADD CONSTRAINT "SYS_C0017780" CHECK ("EWW_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_EARLY_WARNING_WORK
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_24_I" AFTER INSERT ON "JACK"."TB_EARLY_WARNING_WORK" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_EARLY_WARNING_WORK"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_EARLY_WARNING_WORK"','276650610','insert',''''||:new."EWW_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_25_U" AFTER UPDATE ON "JACK"."TB_EARLY_WARNING_WORK" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_EARLY_WARNING_WORK"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_EARLY_WARNING_WORK"','276650610','update',''''||:new."EWW_ID"||'''',''''||:old."EWW_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_26_D" AFTER DELETE ON "JACK"."TB_EARLY_WARNING_WORK" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_EARLY_WARNING_WORK"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_EARLY_WARNING_WORK"','276650610','delete',''''||:old."EWW_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_EQUIPMEN
-- ----------------------------
ALTER TABLE "JACK"."TB_EQUIPMEN" ADD CONSTRAINT "SYS_C0032392" PRIMARY KEY ("EQ_ID");

-- ----------------------------
-- Checks structure for table TB_EQUIPMEN
-- ----------------------------
ALTER TABLE "JACK"."TB_EQUIPMEN" ADD CONSTRAINT "SYS_C0013499" CHECK ("EQ_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_EQUIPMEN" ADD CONSTRAINT "SYS_C0027543" CHECK ("EQ_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_EQUIPMEN
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_60_I" AFTER INSERT ON "JACK"."TB_EQUIPMEN" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_EQUIPMEN"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_EQUIPMEN"','276650610','insert',''''||:new."EQ_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_61_U" AFTER UPDATE ON "JACK"."TB_EQUIPMEN" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_EQUIPMEN"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_EQUIPMEN"','276650610','update',''''||:new."EQ_ID"||'''',''''||:old."EQ_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_62_D" AFTER DELETE ON "JACK"."TB_EQUIPMEN" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_EQUIPMEN"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_EQUIPMEN"','276650610','delete',''''||:old."EQ_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Checks structure for table TB_EQUIP_BINDING_WORK
-- ----------------------------
ALTER TABLE "JACK"."TB_EQUIP_BINDING_WORK" ADD CONSTRAINT "SYS_C0013500" CHECK ("EBW_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_EQUIP_BINDING_WORK" ADD CONSTRAINT "SYS_C0027541" CHECK ("EBW_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_IVS_CAMERA
-- ----------------------------
ALTER TABLE "JACK"."TB_IVS_CAMERA" ADD CONSTRAINT "SYS_C0018592" PRIMARY KEY ("CAMERA_ID");

-- ----------------------------
-- Checks structure for table TB_IVS_CAMERA
-- ----------------------------
ALTER TABLE "JACK"."TB_IVS_CAMERA" ADD CONSTRAINT "SYS_C0018591" CHECK ("CAMERA_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_JKGW
-- ----------------------------
ALTER TABLE "JACK"."TB_JKGW" ADD CONSTRAINT "SYS_C0021576" PRIMARY KEY ("GW_ID");

-- ----------------------------
-- Checks structure for table TB_JKGW
-- ----------------------------
ALTER TABLE "JACK"."TB_JKGW" ADD CONSTRAINT "SYS_C0013501" CHECK ("GW_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_JKGW" ADD CONSTRAINT "SYS_C0027568" CHECK ("GW_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_JKGW
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_18_I" AFTER INSERT ON "JACK"."TB_JKGW" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_JKGW"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_JKGW"','276650610','insert',''''||:new."GW_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_19_U" AFTER UPDATE ON "JACK"."TB_JKGW" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_JKGW"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_JKGW"','276650610','update',''''||:new."GW_ID"||'''',''''||:old."GW_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_20_D" AFTER DELETE ON "JACK"."TB_JKGW" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_JKGW"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_JKGW"','276650610','delete',''''||:old."GW_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_JKXT
-- ----------------------------
ALTER TABLE "JACK"."TB_JKXT" ADD CONSTRAINT "PK_JKXT" PRIMARY KEY ("JK_ID");

-- ----------------------------
-- Checks structure for table TB_JKXT
-- ----------------------------
ALTER TABLE "JACK"."TB_JKXT" ADD CONSTRAINT "SYS_C0011055" CHECK ("JK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_JKXT" ADD CONSTRAINT "SYS_C0017784" CHECK ("JK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_OP_WORK
-- ----------------------------
ALTER TABLE "JACK"."TB_OP_WORK" ADD CONSTRAINT "SYS_C0014664" PRIMARY KEY ("OP_WORK_ID");

-- ----------------------------
-- Checks structure for table TB_OP_WORK
-- ----------------------------
ALTER TABLE "JACK"."TB_OP_WORK" ADD CONSTRAINT "SYS_C0014333" CHECK ("OP_WORK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_OP_WORK" ADD CONSTRAINT "SYS_C0014663" CHECK ("OP_WORK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_OP_WORK" ADD CONSTRAINT "SYS_C0015296" CHECK ("OP_WORK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_OP_WORK" ADD CONSTRAINT "SYS_C0015994" CHECK ("OP_WORK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_OP_WORK" ADD CONSTRAINT "SYS_C0017345" CHECK ("OP_WORK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_OP_WORK" ADD CONSTRAINT "SYS_C0017785" CHECK ("OP_WORK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_OP_WORK
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_72_I" AFTER INSERT ON "JACK"."TB_OP_WORK" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_OP_WORK"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_OP_WORK"','276650610','insert',''''||:new."OP_WORK_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_73_U" AFTER UPDATE ON "JACK"."TB_OP_WORK" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_OP_WORK"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_OP_WORK"','276650610','update',''''||:new."OP_WORK_ID"||'''',''''||:old."OP_WORK_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_74_D" AFTER DELETE ON "JACK"."TB_OP_WORK" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_OP_WORK"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_OP_WORK"','276650610','delete',''''||:old."OP_WORK_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Checks structure for table TB_POLE_QRCODE_BIND_HISTORY
-- ----------------------------
ALTER TABLE "JACK"."TB_POLE_QRCODE_BIND_HISTORY" ADD CONSTRAINT "SYS_C0013504" CHECK ("PQBH_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_POLE_QRCODE_BIND_HISTORY" ADD CONSTRAINT "SYS_C0027548" CHECK ("PQBH_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_PRIVILEGE" ADD CONSTRAINT "SYS_C0011133" PRIMARY KEY ("PRIVILEGE_ID");

-- ----------------------------
-- Uniques structure for table TB_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_PRIVILEGE" ADD CONSTRAINT "UNIQ_PRIVILEGE_CODE" UNIQUE ("PRIVILEGE_CODE") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table TB_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_PRIVILEGE" ADD CONSTRAINT "SYS_C0011132" CHECK ("PRIVILEGE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_PRIVILEGE" ADD CONSTRAINT "SYS_C0019106" CHECK ("PRIVILEGE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_PRIVILEGE
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_3_I" AFTER INSERT ON "JACK"."TB_PRIVILEGE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_PRIVILEGE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_PRIVILEGE"','276650610','insert',''''||:new."PRIVILEGE_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_4_U" AFTER UPDATE ON "JACK"."TB_PRIVILEGE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_PRIVILEGE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_PRIVILEGE"','276650610','update',''''||:new."PRIVILEGE_ID"||'''',''''||:old."PRIVILEGE_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_5_D" AFTER DELETE ON "JACK"."TB_PRIVILEGE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_PRIVILEGE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_PRIVILEGE"','276650610','delete',''''||:old."PRIVILEGE_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_QDSXJ
-- ----------------------------
ALTER TABLE "JACK"."TB_QDSXJ" ADD CONSTRAINT "PK_SXJ" PRIMARY KEY ("SB_ID");

-- ----------------------------
-- Checks structure for table TB_QDSXJ
-- ----------------------------
ALTER TABLE "JACK"."TB_QDSXJ" ADD CONSTRAINT "SYS_C0011115" CHECK ("SB_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_QDSXJ" ADD CONSTRAINT "SYS_C0017670" CHECK ("SB_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_QDSXJ" ADD CONSTRAINT "SYS_C0017788" CHECK ("SB_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_QDSXJ
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_30_I" AFTER INSERT ON "JACK"."TB_QDSXJ" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_QDSXJ"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_QDSXJ"','276650610','insert',''''||:new."SB_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_31_U" AFTER UPDATE ON "JACK"."TB_QDSXJ" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_QDSXJ"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_QDSXJ"','276650610','update',''''||:new."SB_ID"||'''',''''||:old."SB_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_32_D" AFTER DELETE ON "JACK"."TB_QDSXJ" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_QDSXJ"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_QDSXJ"','276650610','delete',''''||:old."SB_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_QRCODE
-- ----------------------------
ALTER TABLE "JACK"."TB_QRCODE" ADD CONSTRAINT "PK_QRID" PRIMARY KEY ("QR_ID");

-- ----------------------------
-- Checks structure for table TB_QRCODE
-- ----------------------------
ALTER TABLE "JACK"."TB_QRCODE" ADD CONSTRAINT "SYS_C0011118" CHECK ("QR_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_QRCODE" ADD CONSTRAINT "SYS_C0017673" CHECK ("QR_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_QRCODE" ADD CONSTRAINT "SYS_C0017789" CHECK ("QR_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_QRCODE" ADD CONSTRAINT "SYS_C0021016" CHECK ("QR_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_QRCODE" ADD CONSTRAINT "SYS_C0027906" CHECK ("QR_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_QRCODE
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_10_U" AFTER UPDATE ON "JACK"."TB_QRCODE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_QRCODE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_QRCODE"','276650610','update',''''||:new."QR_ID"||'''',''''||:old."QR_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_11_D" AFTER DELETE ON "JACK"."TB_QRCODE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_QRCODE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_QRCODE"','276650610','delete',''''||:old."QR_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_9_I" AFTER INSERT ON "JACK"."TB_QRCODE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_QRCODE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_QRCODE"','276650610','insert',''''||:new."QR_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_ROLE
-- ----------------------------
ALTER TABLE "JACK"."TB_ROLE" ADD CONSTRAINT "PK_ROLE_ID" PRIMARY KEY ("ROLE_ID");

-- ----------------------------
-- Checks structure for table TB_ROLE
-- ----------------------------
ALTER TABLE "JACK"."TB_ROLE" ADD CONSTRAINT "SYS_C0011063" CHECK ("ROLE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_ROLE" ADD CONSTRAINT "SYS_C0017790" CHECK ("ROLE_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_ROLE
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_0_I" AFTER INSERT ON "JACK"."TB_ROLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_ROLE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_ROLE"','276650610','insert',''''||:new."ROLE_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_1_U" AFTER UPDATE ON "JACK"."TB_ROLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_ROLE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_ROLE"','276650610','update',''''||:new."ROLE_ID"||'''',''''||:old."ROLE_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_2_D" AFTER DELETE ON "JACK"."TB_ROLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_ROLE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_ROLE"','276650610','delete',''''||:old."ROLE_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_ROLE_DATA_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_ROLE_DATA_PRIVILEGE" ADD CONSTRAINT "SYS_C0011109" PRIMARY KEY ("RDP_ID");

-- ----------------------------
-- Checks structure for table TB_ROLE_DATA_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_ROLE_DATA_PRIVILEGE" ADD CONSTRAINT "SYS_C0011108" CHECK ("RDP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_ROLE_DATA_PRIVILEGE" ADD CONSTRAINT "SYS_C0017791" CHECK ("RDP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_ROLE_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_ROLE_PRIVILEGE" ADD CONSTRAINT "SYS_C0011095" PRIMARY KEY ("RP_ID");

-- ----------------------------
-- Checks structure for table TB_ROLE_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_ROLE_PRIVILEGE" ADD CONSTRAINT "SYS_C0011094" CHECK ("RP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_ROLE_PRIVILEGE" ADD CONSTRAINT "SYS_C0017792" CHECK ("RP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_ROLE_PRIVILEGE
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_39_I" AFTER INSERT ON "JACK"."TB_ROLE_PRIVILEGE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_ROLE_PRIVILEGE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_ROLE_PRIVILEGE"','276650610','insert',''''||:new."RP_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_40_U" AFTER UPDATE ON "JACK"."TB_ROLE_PRIVILEGE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_ROLE_PRIVILEGE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_ROLE_PRIVILEGE"','276650610','update',''''||:new."RP_ID"||'''',''''||:old."RP_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_41_D" AFTER DELETE ON "JACK"."TB_ROLE_PRIVILEGE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_ROLE_PRIVILEGE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_ROLE_PRIVILEGE"','276650610','delete',''''||:old."RP_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Checks structure for table TB_SERVER_WORK
-- ----------------------------
ALTER TABLE "JACK"."TB_SERVER_WORK" ADD CONSTRAINT "SYS_C0013511" CHECK ("SW_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_SERVER_WORK" ADD CONSTRAINT "SYS_C0027550" CHECK ("SW_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_SP_GRANT
-- ----------------------------
ALTER TABLE "JACK"."TB_SP_GRANT" ADD CONSTRAINT "PK_GRANT_ID" PRIMARY KEY ("SP_GRANT_ID");

-- ----------------------------
-- Checks structure for table TB_SP_GRANT
-- ----------------------------
ALTER TABLE "JACK"."TB_SP_GRANT" ADD CONSTRAINT "SYS_C0011068" CHECK ("SP_GRANT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_SP_GRANT" ADD CONSTRAINT "SYS_C0017794" CHECK ("SP_GRANT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_SP_GRANT
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_69_I" AFTER INSERT ON "JACK"."TB_SP_GRANT" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_SP_GRANT"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_SP_GRANT"','276650610','insert',''''||:new."SP_GRANT_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_70_U" AFTER UPDATE ON "JACK"."TB_SP_GRANT" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_SP_GRANT"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_SP_GRANT"','276650610','update',''''||:new."SP_GRANT_ID"||'''',''''||:old."SP_GRANT_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_71_D" AFTER DELETE ON "JACK"."TB_SP_GRANT" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_SP_GRANT"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_SP_GRANT"','276650610','delete',''''||:old."SP_GRANT_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_SP_GRANT_VIEW_TIME_SPAN
-- ----------------------------
ALTER TABLE "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN" ADD CONSTRAINT "SYS_C0019996" PRIMARY KEY ("TS_ID");

-- ----------------------------
-- Checks structure for table TB_SP_GRANT_VIEW_TIME_SPAN
-- ----------------------------
ALTER TABLE "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN" ADD CONSTRAINT "SYS_C0019994" CHECK ("TS_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN" ADD CONSTRAINT "SYS_C0019995" CHECK ("SP_GRANT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_SP_GRANT_VIEW_TIME_SPAN
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_33_I" AFTER INSERT ON "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_SP_GRANT_VIEW_TIME_SPAN"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_SP_GRANT_VIEW_TIME_SPAN"','276650610','insert',''''||:new."TS_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_34_U" AFTER UPDATE ON "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_SP_GRANT_VIEW_TIME_SPAN"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_SP_GRANT_VIEW_TIME_SPAN"','276650610','update',''''||:new."TS_ID"||'''',''''||:old."TS_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_35_D" AFTER DELETE ON "JACK"."TB_SP_GRANT_VIEW_TIME_SPAN" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_SP_GRANT_VIEW_TIME_SPAN"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_SP_GRANT_VIEW_TIME_SPAN"','276650610','delete',''''||:old."TS_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_TEMP_USER
-- ----------------------------
ALTER TABLE "JACK"."TB_TEMP_USER" ADD CONSTRAINT "SYS_C0011176" PRIMARY KEY ("TMP_USER_ID");

-- ----------------------------
-- Uniques structure for table TB_TEMP_USER
-- ----------------------------
ALTER TABLE "JACK"."TB_TEMP_USER" ADD CONSTRAINT "UNIQ_TEMP_USER_NAME" UNIQUE ("TEMP_USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table TB_TEMP_USER
-- ----------------------------
ALTER TABLE "JACK"."TB_TEMP_USER" ADD CONSTRAINT "SYS_C0011175" CHECK ("TMP_USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_TEMP_USER" ADD CONSTRAINT "SYS_C0014898" CHECK ("TMP_USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_TEMP_USER" ADD CONSTRAINT "SYS_C0027552" CHECK ("TMP_USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table TB_TEMP_USER_BIND_JKGW
-- ----------------------------
ALTER TABLE "JACK"."TB_TEMP_USER_BIND_JKGW" ADD CONSTRAINT "SYS_C0014902" CHECK ("TUBJ_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_TEMP_USER_BIND_JKGW" ADD CONSTRAINT "SYS_C0027557" CHECK ("TUBJ_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_TEMP_USER_EQUIP_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE" ADD CONSTRAINT "SYS_C0013091" PRIMARY KEY ("RUEP_ID");

-- ----------------------------
-- Uniques structure for table TB_TEMP_USER_EQUIP_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE" ADD CONSTRAINT "UNIQ_TMP_USER_ID" UNIQUE ("TMP_USER_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table TB_TEMP_USER_EQUIP_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE" ADD CONSTRAINT "SYS_C0013090" CHECK ("RUEP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE" ADD CONSTRAINT "SYS_C0014903" CHECK ("RUEP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_TEMP_USER_EQUIP_PRIVILEGE" ADD CONSTRAINT "SYS_C0027559" CHECK ("RUEP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table TB_TEMP_USER_HISTORIC_POSITION
-- ----------------------------
CREATE INDEX "JACK"."INDEX_TMP_USER_ID"
  ON "JACK"."TB_TEMP_USER_HISTORIC_POSITION" ("TMP_USER_ID" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table TB_TEST_QDSXJ
-- ----------------------------
ALTER TABLE "JACK"."TB_TEST_QDSXJ" ADD CONSTRAINT "SYS_C0032377" PRIMARY KEY ("SB_ID");

-- ----------------------------
-- Checks structure for table TB_TEST_QDSXJ
-- ----------------------------
ALTER TABLE "JACK"."TB_TEST_QDSXJ" ADD CONSTRAINT "SYS_C0017901" CHECK ("SB_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_TEST_QDSXJ
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_45_I" AFTER INSERT ON "JACK"."TB_TEST_QDSXJ" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_TEST_QDSXJ"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_TEST_QDSXJ"','276650610','insert',''''||:new."SB_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_46_U" AFTER UPDATE ON "JACK"."TB_TEST_QDSXJ" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_TEST_QDSXJ"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_TEST_QDSXJ"','276650610','update',''''||:new."SB_ID"||'''',''''||:old."SB_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_47_D" AFTER DELETE ON "JACK"."TB_TEST_QDSXJ" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_TEST_QDSXJ"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_TEST_QDSXJ"','276650610','delete',''''||:old."SB_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_THIRD_PLATFORM_USER
-- ----------------------------
ALTER TABLE "JACK"."TB_THIRD_PLATFORM_USER" ADD CONSTRAINT "SYS_C0011147" PRIMARY KEY ("TPU_ID");

-- ----------------------------
-- Checks structure for table TB_THIRD_PLATFORM_USER
-- ----------------------------
ALTER TABLE "JACK"."TB_THIRD_PLATFORM_USER" ADD CONSTRAINT "SYS_C0011146" CHECK ("TPU_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_THIRD_PLATFORM_USER" ADD CONSTRAINT "SYS_C0014907" CHECK ("TPU_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_THIRD_PLATFORM_USER" ADD CONSTRAINT "SYS_C0027564" CHECK ("TPU_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_USER
-- ----------------------------
ALTER TABLE "JACK"."TB_USER" ADD CONSTRAINT "PK_USER_ID" PRIMARY KEY ("USER_ID");

-- ----------------------------
-- Checks structure for table TB_USER
-- ----------------------------
ALTER TABLE "JACK"."TB_USER" ADD CONSTRAINT "SYS_C0011065" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_USER" ADD CONSTRAINT "SYS_C0017800" CHECK ("USER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_USER
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_21_I" AFTER INSERT ON "JACK"."TB_USER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USER"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USER"','276650610','insert',''''||:new."USER_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_22_U" AFTER UPDATE ON "JACK"."TB_USER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_USER"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USER"','276650610','update',''''||:new."USER_ID"||'''',''''||:old."USER_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_23_D" AFTER DELETE ON "JACK"."TB_USER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USER"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USER"','276650610','delete',''''||:old."USER_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_USERGROUP
-- ----------------------------
ALTER TABLE "JACK"."TB_USERGROUP" ADD CONSTRAINT "SYS_C0011091" PRIMARY KEY ("UG_ID");

-- ----------------------------
-- Checks structure for table TB_USERGROUP
-- ----------------------------
ALTER TABLE "JACK"."TB_USERGROUP" ADD CONSTRAINT "SYS_C0011090" CHECK ("UG_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_USERGROUP" ADD CONSTRAINT "SYS_C0017801" CHECK ("UG_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_USERGROUP
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_66_I" AFTER INSERT ON "JACK"."TB_USERGROUP" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USERGROUP"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USERGROUP"','276650610','insert',''''||:new."UG_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_67_U" AFTER UPDATE ON "JACK"."TB_USERGROUP" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_USERGROUP"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USERGROUP"','276650610','update',''''||:new."UG_ID"||'''',''''||:old."UG_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_68_D" AFTER DELETE ON "JACK"."TB_USERGROUP" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USERGROUP"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USERGROUP"','276650610','delete',''''||:old."UG_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_USERGROUP_ROLE
-- ----------------------------
ALTER TABLE "JACK"."TB_USERGROUP_ROLE" ADD CONSTRAINT "SYS_C0011099" PRIMARY KEY ("UGR_ID");

-- ----------------------------
-- Checks structure for table TB_USERGROUP_ROLE
-- ----------------------------
ALTER TABLE "JACK"."TB_USERGROUP_ROLE" ADD CONSTRAINT "SYS_C0011098" CHECK ("UGR_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_USERGROUP_ROLE" ADD CONSTRAINT "SYS_C0017802" CHECK ("UGR_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_USERGROUP_ROLE
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_54_I" AFTER INSERT ON "JACK"."TB_USERGROUP_ROLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USERGROUP_ROLE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USERGROUP_ROLE"','276650610','insert',''''||:new."UGR_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_55_U" AFTER UPDATE ON "JACK"."TB_USERGROUP_ROLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_USERGROUP_ROLE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USERGROUP_ROLE"','276650610','update',''''||:new."UGR_ID"||'''',''''||:old."UGR_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_56_D" AFTER DELETE ON "JACK"."TB_USERGROUP_ROLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USERGROUP_ROLE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USERGROUP_ROLE"','276650610','delete',''''||:old."UGR_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_USERGROUP_USER
-- ----------------------------
ALTER TABLE "JACK"."TB_USERGROUP_USER" ADD CONSTRAINT "SYS_C0011101" PRIMARY KEY ("UGU_ID");

-- ----------------------------
-- Checks structure for table TB_USERGROUP_USER
-- ----------------------------
ALTER TABLE "JACK"."TB_USERGROUP_USER" ADD CONSTRAINT "SYS_C0011100" CHECK ("UGU_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_USERGROUP_USER" ADD CONSTRAINT "SYS_C0017803" CHECK ("UGU_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_USERGROUP_USER
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_42_I" AFTER INSERT ON "JACK"."TB_USERGROUP_USER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USERGROUP_USER"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USERGROUP_USER"','276650610','insert',''''||:new."UGU_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_43_U" AFTER UPDATE ON "JACK"."TB_USERGROUP_USER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_USERGROUP_USER"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USERGROUP_USER"','276650610','update',''''||:new."UGU_ID"||'''',''''||:old."UGU_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_44_D" AFTER DELETE ON "JACK"."TB_USERGROUP_USER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USERGROUP_USER"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USERGROUP_USER"','276650610','delete',''''||:old."UGU_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_USERTYPE_DATA_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_USERTYPE_DATA_PRIVILEGE" ADD CONSTRAINT "SYS_C0011107" PRIMARY KEY ("UTDP_ID");

-- ----------------------------
-- Checks structure for table TB_USERTYPE_DATA_PRIVILEGE
-- ----------------------------
ALTER TABLE "JACK"."TB_USERTYPE_DATA_PRIVILEGE" ADD CONSTRAINT "SYS_C0011106" CHECK ("UTDP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_USERTYPE_DATA_PRIVILEGE" ADD CONSTRAINT "SYS_C0017804" CHECK ("UTDP_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TB_USER_MESSAGE
-- ----------------------------
ALTER TABLE "JACK"."TB_USER_MESSAGE" ADD CONSTRAINT "SYS_C0032084" PRIMARY KEY ("user_msg_id");

-- ----------------------------
-- Triggers structure for table TB_USER_MESSAGE
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_48_I" AFTER INSERT ON "JACK"."TB_USER_MESSAGE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USER_MESSAGE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USER_MESSAGE"','276650610','insert',''''||:new."user_msg_id"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_49_U" AFTER UPDATE ON "JACK"."TB_USER_MESSAGE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_USER_MESSAGE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USER_MESSAGE"','276650610','update',''''||:new."user_msg_id"||'''',''''||:old."user_msg_id"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_50_D" AFTER DELETE ON "JACK"."TB_USER_MESSAGE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USER_MESSAGE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USER_MESSAGE"','276650610','delete',''''||:old."user_msg_id"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_USER_ROLE
-- ----------------------------
ALTER TABLE "JACK"."TB_USER_ROLE" ADD CONSTRAINT "SYS_C0011097" PRIMARY KEY ("UR_ID");

-- ----------------------------
-- Checks structure for table TB_USER_ROLE
-- ----------------------------
ALTER TABLE "JACK"."TB_USER_ROLE" ADD CONSTRAINT "SYS_C0011096" CHECK ("UR_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_USER_ROLE" ADD CONSTRAINT "SYS_C0017805" CHECK ("UR_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_USER_ROLE
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_15_I" AFTER INSERT ON "JACK"."TB_USER_ROLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USER_ROLE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USER_ROLE"','276650610','insert',''''||:new."UR_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_16_U" AFTER UPDATE ON "JACK"."TB_USER_ROLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_USER_ROLE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USER_ROLE"','276650610','update',''''||:new."UR_ID"||'''',''''||:old."UR_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_17_D" AFTER DELETE ON "JACK"."TB_USER_ROLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_USER_ROLE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_USER_ROLE"','276650610','delete',''''||:old."UR_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_WORK
-- ----------------------------
ALTER TABLE "JACK"."TB_WORK" ADD CONSTRAINT "PK_WK_ID" PRIMARY KEY ("WK_ID");

-- ----------------------------
-- Checks structure for table TB_WORK
-- ----------------------------
ALTER TABLE "JACK"."TB_WORK" ADD CONSTRAINT "SYS_C0011073" CHECK ("WK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_WORK" ADD CONSTRAINT "SYS_C0017806" CHECK ("WK_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_WORK
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_6_I" AFTER INSERT ON "JACK"."TB_WORK" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_WORK"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK"','276650610','insert',''''||:new."WK_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_7_U" AFTER UPDATE ON "JACK"."TB_WORK" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_WORK"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK"','276650610','update',''''||:new."WK_ID"||'''',''''||:old."WK_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_8_D" AFTER DELETE ON "JACK"."TB_WORK" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_WORK"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK"','276650610','delete',''''||:old."WK_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_WORK_DEVICE_DATE
-- ----------------------------
ALTER TABLE "JACK"."TB_WORK_DEVICE_DATE" ADD CONSTRAINT "SYS_C0018311" PRIMARY KEY ("WORK_DEVICE_ID");

-- ----------------------------
-- Triggers structure for table TB_WORK_DEVICE_DATE
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_36_I" AFTER INSERT ON "JACK"."TB_WORK_DEVICE_DATE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_WORK_DEVICE_DATE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK_DEVICE_DATE"','276650610','insert',''''||:new."WORK_DEVICE_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_37_U" AFTER UPDATE ON "JACK"."TB_WORK_DEVICE_DATE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_WORK_DEVICE_DATE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK_DEVICE_DATE"','276650610','update',''''||:new."WORK_DEVICE_ID"||'''',''''||:old."WORK_DEVICE_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_38_D" AFTER DELETE ON "JACK"."TB_WORK_DEVICE_DATE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_WORK_DEVICE_DATE"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK_DEVICE_DATE"','276650610','delete',''''||:old."WORK_DEVICE_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_WORK_SP_CONFIG
-- ----------------------------
ALTER TABLE "JACK"."TB_WORK_SP_CONFIG" ADD CONSTRAINT "SYS_C0011103" PRIMARY KEY ("WKCFG_ID");

-- ----------------------------
-- Checks structure for table TB_WORK_SP_CONFIG
-- ----------------------------
ALTER TABLE "JACK"."TB_WORK_SP_CONFIG" ADD CONSTRAINT "SYS_C0011102" CHECK ("WKCFG_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_WORK_SP_CONFIG" ADD CONSTRAINT "SYS_C0017807" CHECK ("WKCFG_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_WORK_SP_CONFIG
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_57_I" AFTER INSERT ON "JACK"."TB_WORK_SP_CONFIG" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_WORK_SP_CONFIG"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK_SP_CONFIG"','276650610','insert',''''||:new."WKCFG_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_58_U" AFTER UPDATE ON "JACK"."TB_WORK_SP_CONFIG" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_WORK_SP_CONFIG"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK_SP_CONFIG"','276650610','update',''''||:new."WKCFG_ID"||'''',''''||:old."WKCFG_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_59_D" AFTER DELETE ON "JACK"."TB_WORK_SP_CONFIG" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_WORK_SP_CONFIG"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK_SP_CONFIG"','276650610','delete',''''||:old."WKCFG_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_WORK_SP_HISTORY
-- ----------------------------
ALTER TABLE "JACK"."TB_WORK_SP_HISTORY" ADD CONSTRAINT "SYS_C0011105" PRIMARY KEY ("WKHIS_ID");

-- ----------------------------
-- Checks structure for table TB_WORK_SP_HISTORY
-- ----------------------------
ALTER TABLE "JACK"."TB_WORK_SP_HISTORY" ADD CONSTRAINT "SYS_C0011104" CHECK ("WKHIS_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_WORK_SP_HISTORY" ADD CONSTRAINT "SYS_C0017808" CHECK ("WKHIS_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table TB_WORK_SP_HISTORY
-- ----------------------------
CREATE TRIGGER "JACK"."T_276650610_27_I" AFTER INSERT ON "JACK"."TB_WORK_SP_HISTORY" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_WORK_SP_HISTORY"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey) 	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK_SP_HISTORY"','276650610','insert',''''||:new."WKHIS_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_28_U" AFTER UPDATE ON "JACK"."TB_WORK_SP_HISTORY" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM topwalk_dtp_select_tb	 WHERE table_name='"JACK"."TB_WORK_SP_HISTORY"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO	topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey,action_oldprimarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK_SP_HISTORY"','276650610','update',''''||:new."WKHIS_ID"||'''',''''||:old."WKHIS_ID"||'''');
END IF;
END;
/
CREATE TRIGGER "JACK"."T_276650610_29_D" AFTER DELETE ON "JACK"."TB_WORK_SP_HISTORY" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE ACTION NUMBER;
BEGIN
SELECT action_state INTO ACTION FROM	 topwalk_dtp_select_tb WHERE table_name='"JACK"."TB_WORK_SP_HISTORY"' and table_task = '276650610'; 
 IF(ACTION = 0)THEN 
 INSERT INTO topwalk_dtp_276650610_tb(action_id,action_object,task_name,action_name,action_primarykey)	 
 VALUES(topwalk_sequence_id.nextval,'"JACK"."TB_WORK_SP_HISTORY"','276650610','delete',''''||:old."WKHIS_ID"||'''');
END IF;
END;
/

-- ----------------------------
-- Primary Key structure for table TB_YJYD
-- ----------------------------
ALTER TABLE "JACK"."TB_YJYD" ADD CONSTRAINT "PK_YJ_ID" PRIMARY KEY ("YJ_ID");

-- ----------------------------
-- Checks structure for table TB_YJYD
-- ----------------------------
ALTER TABLE "JACK"."TB_YJYD" ADD CONSTRAINT "SYS_C0011079" CHECK ("YJ_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TB_YJYD" ADD CONSTRAINT "SYS_C0017809" CHECK ("YJ_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table TOPWALK_DTP_276650610_TB
-- ----------------------------
ALTER TABLE "JACK"."TOPWALK_DTP_276650610_TB" ADD CONSTRAINT "TOPWALK_DTP_276650610" PRIMARY KEY ("ACTION_ID");

-- ----------------------------
-- Checks structure for table TOPWALK_DTP_276650610_TB
-- ----------------------------
ALTER TABLE "JACK"."TOPWALK_DTP_276650610_TB" ADD CONSTRAINT "SYS_C0032387" CHECK ("TASK_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TOPWALK_DTP_276650610_TB" ADD CONSTRAINT "SYS_C0032388" CHECK ("ACTION_OBJECT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TOPWALK_DTP_276650610_TB" ADD CONSTRAINT "SYS_C0032389" CHECK ("ACTION_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TOPWALK_DTP_276650610_TB" ADD CONSTRAINT "SYS_C0032390" CHECK ("ACTION_PRIMARYKEY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Indexes structure for table TOPWALK_DTP_276650610_TB
-- ----------------------------
CREATE INDEX "JACK"."TOPWALK_DTP_276650610_TB_INDEX"
  ON "JACK"."TOPWALK_DTP_276650610_TB" ("TASK_NAME" ASC)
  LOGGING
  VISIBLE
PCTFREE 10
INITRANS 2
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  FREELISTS 1
  FREELIST GROUPS 1
  BUFFER_POOL DEFAULT
);

-- ----------------------------
-- Primary Key structure for table TOPWALK_DTP_SELECT_TB
-- ----------------------------
ALTER TABLE "JACK"."TOPWALK_DTP_SELECT_TB" ADD CONSTRAINT "PK_TOPWALK_DTP_SELECT_TB" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table TOPWALK_DTP_SELECT_TB
-- ----------------------------
ALTER TABLE "JACK"."TOPWALK_DTP_SELECT_TB" ADD CONSTRAINT "SYS_C0032383" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "JACK"."TOPWALK_DTP_SELECT_TB" ADD CONSTRAINT "SYS_C0032384" CHECK ("TABLE_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
